migrating data from excel

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
yaron
Forum Contributor
Posts: 157
Joined: Fri Aug 22, 2003 8:40 am

migrating data from excel

Post by yaron »

How can migrate data form excel sheet to mysql database?
I've heard that to import *.csv file might be helpful but I don't really know what is *.csv and how can i use it.
andy ideas?
User avatar
Jean-Yves
Forum Contributor
Posts: 148
Joined: Wed Jul 02, 2003 2:13 pm
Location: West Country, UK

Post by Jean-Yves »

MySQL provides a syntax for doing this, see the manual, "4.8.7 mysqlimport".

Alternatively, the easiest way is to grab a GUI such as SQLyog and use that to select the CSV file, state how rows and columns are delimited, and click OK! :)
m3rajk
DevNet Resident
Posts: 1191
Joined: Mon Jun 02, 2003 3:37 pm

Post by m3rajk »

CSV == Comma Seperated Volume

excel can read these, even write to them
Post Reply