Converting Excel to Mysql Tutorial

klyau23 · July 15th, 2005, 09:25 PM

Hi All,

Wondering on how to convert excel spreadsheet to MYSQL database easily without incurring any cost? Visit this web site

http://excel2mysql.f2g.net

for a tutorial. By following simple and intuitive steps, you will be able to get a mysql database. But, get a free copy of phpMyadmin from the internet first. It's simple to get it, just type phpmyadmin at the any search engine.

Thanks.

klyau23 · July 21st, 2005, 04:47 AM

New Location due to High Volume Traffic

Hi All,

Thanks for visiting my web site. Due to high traffic volume, my web site has been exceeding its maximum bandwidth. Please visit one of the following similar web pages.

http://excel2mysqlforum.f2g.net
http://excel2mysql.f2g.net

Thanks. And sorry for any inconvenience caused.

narendra12345 · May 11th, 2007, 08:31 AM

Hi ,
I need t import excel into mysql database.
i havse searched your site .I didn't get any help.Kindly let me know how can i do this. Can i get code form any where.
Kindly help
Thanks and Regards,
Narendra

utcursch · May 12th, 2007, 07:56 AM

Simply export data from excel as CSV. Than use MySQL command

Code:

LOAD DATA INFILE 'path/file.txt' INTO TABLE your_table;

Check MySQL documentation for more information on LOAD DATA INFILE:
http://dev.mysql.com/doc/refman/5.0/en/load-data.html

ut