1,105,331 Community Members

import excel file into sql

Member Avatar
navneet patel
Newbie Poster
1 post since Dec 2012
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

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

Member Avatar
pritaeas
mod_pritaeas
11,285 posts since Jul 2006
Reputation Points: 1,420 [?]
Q&As Helped to Solve: 1,831 [?]
Skill Endorsements: 154 [?]
Moderator
Featured
Sponsor
 
0
 

Which database? There are tools to help you.

Member Avatar
gon1387
Posting Whiz in Training
242 posts since Jan 2011
Reputation Points: 22 [?]
Q&As Helped to Solve: 38 [?]
Skill Endorsements: 4 [?]
 
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.

Member Avatar
radhakrishna.p
Posting Whiz in Training
281 posts since Nov 2012
Reputation Points: 29 [?]
Q&As Helped to Solve: 64 [?]
Skill Endorsements: 11 [?]
 
0
 

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

Member Avatar
diafol
Where are my eyes?
12,941 posts since Oct 2006
Reputation Points: 1,821 [?]
Q&As Helped to Solve: 1,845 [?]
Skill Endorsements: 90 [?]
Moderator
Featured
Sponsor
 
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.

Member Avatar
dmsoft
Newbie Poster
3 posts since Feb 2008
Reputation Points: 0 [?]
Q&As Helped to Solve: 1 [?]
Skill Endorsements: 0 [?]
 
0
 

You can use this software to export your Excel file

Member Avatar
jkon
Posting Pro in Training
441 posts since Jan 2009
Reputation Points: 110 [?]
Q&As Helped to Solve: 73 [?]
Skill Endorsements: 6 [?]
 
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 three months: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: