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 :D

Re: Import CSV file directly into MySQL

Posted: Mon Oct 05, 2009 12:39 pm
by lauthiamkok
akuji36 wrote: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 :D
got it thanks. managed to sort it out with phpmyadmin. thanks! :mrgreen: