Page 1 of 1
Import CSV file directly into MySQL
Posted: Mon Oct 05, 2009 6:42 am
by lauthiamkok
Hi,
How can I import the data from a spreadsheet into MySQL database? Are there many ways to do this with or without using php?
Many thanks,
Lau
Re: Import CSV file directly into MySQL
Posted: Mon Oct 05, 2009 10:57 am
by akuji36
Hello
There are quite a few programs that can help you manage mysql databases:
I prefer phpmyadmin.
here are some alternatives:
http://www.heidisql.com/
or
http://www.mysqlfront.de/.
or
this example
http://www.sqldbu.com/eng/sections/tips ... mport.html
thanks
Rod Russell
webpagesofease.com

Re: Import CSV file directly into MySQL
Posted: Mon Oct 05, 2009 12:39 pm
by lauthiamkok
got it thanks. managed to sort it out with phpmyadmin. thanks!
