Converting Excel-spreadsheets into MySQL databases

nitroid · 09-19-2005, 06:41 AM

I need a way to convert a bunch of Excel spreadsheets into MySQL database form, and only found non-free Windows programs for that. And of course i need it for Linux.

Any suggestions? Preferably something that works without a GUI.

michaelk · 09-19-2005, 08:03 AM

A quick search didn't find anything usefull.
My first thought would be to convert the spreadsheets to a csv file.
Create a bash script to create a table and import.
http://dev.mysql.com/doc/mysql/en/mysqlimport.html

nitroid · 09-19-2005, 09:02 AM

That sounds like an option, michaelk. But now i also need a script that converts Excel spreadsheets into CSV format

The thing is I need a way to make it happen via a web interface on my server, without having to use a spreadsheet program or anything else than a command line app or a script.

michaelk · 09-19-2005, 06:27 PM

Quote:

The thing is I need a way to make it happen via a web interface on my server, without having to use a spreadsheet program or anything else than a command line app or a script.

This requires a little more thinking....

michaelk · 09-19-2005, 06:37 PM

I found this website that might show some promise.
There are c and perl programs for reading an Excel file which you could use to write an application to create a CSV or input directly to mysql.
http://chicago.sourceforge.net/devel/docs/excel/

nitroid · 09-20-2005, 05:34 AM

Thanks, that looks really promising. I don't think this is going to be easy since I can't really code much, but this will get me started with both the project I'm working on and learning to code. Good thing I'm not in a hurry with making this work.

This doesn't mean I'm not open for further - and possibly easier - suggestions

bathory · 09-20-2005, 05:55 AM

Openoffice can directly save a .xls file into csv format (I think that excel can do this also).
Just hit "Save as..." and select the csv format. There you can specify the field delimiter and you're done.
Then run "mysqlimport -c ..." to import the data in a database you've created.

Melsync · 04-03-2006, 05:52 AM

has anyone tried this perl script at sourceforge or any other alternative?
Thanks