Excel into Mysql
Posted: Sun Jul 25, 2004 9:20 pm
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!
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!