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
Import CSV file directly into MySQL
Moderator: General Moderators
-
lauthiamkok
- Forum Contributor
- Posts: 153
- Joined: Wed Apr 01, 2009 2:23 pm
- Location: Plymouth, United Kingdom
- akuji36
- Forum Contributor
- Posts: 190
- Joined: Tue Oct 14, 2008 9:53 am
- Location: Hartford, Connecticut
Re: Import CSV file directly into MySQL
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
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
-
lauthiamkok
- Forum Contributor
- Posts: 153
- Joined: Wed Apr 01, 2009 2:23 pm
- Location: Plymouth, United Kingdom
Re: Import CSV file directly into MySQL
got it thanks. managed to sort it out with phpmyadmin. thanks!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