Excel File Into MySQL Database

[Mike]

Hi all,

I have a big excel file that needs to be put into a MySQL database. Does anyone know a script or program that will be able to do this? It would be nice if it was free as well, seeing as I'll only be using it once :)

Cheers,
Mike

[agua]

I've used this csv importer (http://scripts.ringsworld.com/database-tools/csv-importer/) with good results in the past to import my excel files to mysql... but you have to save them as a csv.

I found it fairly easy, and I ain't no php/mysql guru :)

[Emancipator]

i just saved mine as a csv and imported it using phpadmin. My excel file had 15,000 records, you may have to use telnet to do it depending on the file size.

[KLB]

I like to use Microsoft Access for this task. I will link to the excel spreadsheet or CSV file via Access and then create an append query to push that data into the MySQL table that Access is also linked to via ODBC.

[Mike]

I tried the CSV importer script, but that didn't seem to install correctly. It turns out that the phpmyadmin method was the easiest and quickest. I was trying to upload the file through the wrong upload form before :)

Thanks guys!