Importing an excel file into mysql db?

MistaT2000 · #1 (**permalink**) 01-16-06, 07:36

Hi there

This is my first post so take it eazy haha

I have quiet alot of data in a excel spreadsheet and was wondering if there was any way I could import that data into a mysql database? Will I have to change the format so its a csv file? Any help would be much appreciated

Cheers

MistaT

mstuhu · #2 (**permalink**) 01-19-06, 09:55

http://sourceforge.net/projects/phpexcelreader/

jfulton · #3 (**permalink**) 01-21-06, 10:38

I'm pretty sure you can just export the .xls file to a csv file. MySQL should be able to import that csv file. Never done it personally, but I'm almost positive it can be done.

http://dev.mysql.com/doc/refman/5.0/en/mysqlimport.html (check the user comments there too.)

jfulton · #4 (**permalink**) 01-21-06, 10:38

I'm pretty sure you can just export the .xls file to a csv file. MySQL should be able to import that csv file. Never done it personally, but it can be done.

http://dev.mysql.com/doc/refman/5.0/en/mysqlimport.html (check the user comments there too.)

ceo4u · #5 (**permalink**) 02-08-06, 17:54

Here's a simple way to convert from CSV to MySQL, goto >>>

http://www.ceo4u.com/data

Enjoy,
Chris

Internet Services

Web Development

Digital Marketing

Consumer Tech