1.11M Members

import excel file into sql

 
0
 

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

 
0
 

Which database? There are tools to help you.

 
0
 

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.

 
0
 

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.

 
0
 

You can use this software to export your Excel file

 
1
 

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.

You
This article has been dead for over six months: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: