...

View Full Version : Excel to mysql conversion



jedimastermopar
11-24-2006, 03:45 PM
I know its a little off topic, but I was wondering if anyone knows of any freeware excel to mysql conversion utilities? There are a lot of pay ones floating around but was hoping for a free one.

timgolding
11-24-2006, 03:55 PM
I can dig up a Excel reader that reads Excel spreadsheets I use it to ouput to a table, so you would have to decode and implement to get it to insert data to SQL. I had to decode it a bit myself and it wasn't to tricky.

Heres an example http://www.jamiesmicroprop.org.uk/sales.php The client inputs changes to the price structure in an excel xls file i then simply upload it to the server and my sales.php page uses the reader.php to show the data as a table.

timgolding
11-24-2006, 03:56 PM
I tried to paste the code but coding forums is strict on char counts so I will host it for you because i am very nice :)

http://pinman-designs.co.uk/files.rar

one is the relavent php from sales.php the other is the reader itself :) enjoy

jedimastermopar
11-24-2006, 06:05 PM
Ahh cool thanks, I just cheaped out and bought a program to do it. Thats a great script though.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum