import excel file into sql

[navneet patel]

i have a excel file of hindi data.
i want to convert in sql database what i do?
please help me

[pritaeas]

Which database? There are tools to help you.

[gon1387]

I've worked with data from excel, preparing the data and converting it to csv using excel first then exporting it to database; it's the easiest way though. LOL :D But never had a chance to work with unicode. Maybe you should try it first, then if you had a problem with regards to the consistency of data, create a program to automate it for you. :)

Anyhow, I would like to know if you really intend to put this thread on PHP, and will be working with PHP. Or should this be on the Databases section.

[radhakrishna.p]

it is posible by using load mysql command (which imports csv file data into database)

you will get the description of load command From the follwing url

http://dev.mysql.com/doc/refman/5.1/en/load-data.html

http://support.modwest.com/content/6/253/en/how-do-i-import-delimited-data-into-mysql.html

If you intend to place Hindi data into a DB, ensure that you have the correct charset and collation set for that particular DB. And for any subsequent php/html page for displaying the data.

[dmsoft]

You can use this software to export your Excel file

[jkon]

Let’s break the issue in parts. What you want to do is to read data from an excel file and the second one is to save those data in DB.
I guess you already know how to do the second part (saving data in DB) so I will suggest for the first part (reading data from excel). For that thing I am using Spreadsheet_Excel_Reader
http://sourceforge.net/projects/phpexcelreader/files/Spreadsheet_Excel_Reader/2i/

The use is quite simple and I can get also data from excel from other languages than English as well. I believe that this is a very good class for reading excels.