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!
[SOLVED] Excel into Mysql
Moderator: General Moderators
-
Paddy
- Forum Contributor
- Posts: 244
- Joined: Wed Jun 11, 2003 8:16 pm
- Location: Hobart, Tas, Aussie
- Contact:
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)
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)