Page 1 of 1

Excel into Mysql

Posted: Sun Jul 25, 2004 9:20 pm
by Paddy
This has been discussed before I here you say! Just CSV it and load in file I hear you say! But alas, no, I work with muppets...

I am just wondering if anyone has touched on this before. What I need to do is be able to upload an excel file to a linux web server and import it into a mysql database automatically. The spreadsheet has multiple sheets.

Any ideas would be greatly appreciated!

Posted: Mon Jul 26, 2004 11:03 am
by lostboy

Posted: Tue Jul 27, 2004 9:13 pm
by Paddy
Thanks lost, but I was hoping for an open source solution.

Posted: Tue Jul 27, 2004 9:25 pm
by feyd
I may be very wrong, but I don't think there are any..

Posted: Tue Jul 27, 2004 10:59 pm
by Paddy
NOOOOOOOOOOOOOOOOOOOO, you are wrong, very wrong.

Ok, maybe you are right. :)

Ok, how about this then. Anyone know how to convert and xls file to a csv file automatically using a linux program that can be executed from a command line?

(Mods, please feel free to move this if it is in the wrong spot now)

Posted: Mon Aug 09, 2004 12:45 am
by Paddy
I found a fix around. I placed a hidden sheet with all the data on it and when they exited forced that worksheet via a macro to be saved as a CSV file. Then they upload the CSV file and all is good.

Just in case anyone is interested...