[SOLVED] Excel into Mysql

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Paddy
Forum Contributor
Posts: 244
Joined: Wed Jun 11, 2003 8:16 pm
Location: Hobart, Tas, Aussie
Contact:

Excel into Mysql

Post 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!
lostboy
Forum Contributor
Posts: 329
Joined: Mon Dec 30, 2002 8:12 pm
Location: toronto,canada

Post by lostboy »

Paddy
Forum Contributor
Posts: 244
Joined: Wed Jun 11, 2003 8:16 pm
Location: Hobart, Tas, Aussie
Contact:

Post by Paddy »

Thanks lost, but I was hoping for an open source solution.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

I may be very wrong, but I don't think there are any..
Paddy
Forum Contributor
Posts: 244
Joined: Wed Jun 11, 2003 8:16 pm
Location: Hobart, Tas, Aussie
Contact:

Post 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)
Paddy
Forum Contributor
Posts: 244
Joined: Wed Jun 11, 2003 8:16 pm
Location: Hobart, Tas, Aussie
Contact:

Post 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...
Post Reply