View Full Version : Excel to mysql conversion
11-24-2006, 02: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.
11-24-2006, 02: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.
11-24-2006, 02: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 :)
one is the relavent php from sales.php the other is the reader itself :) enjoy
11-24-2006, 05:05 PM
Ahh cool thanks, I just cheaped out and bought a program to do it. Thats a great script though.
Powered by vBulletin® Version 4.2.2 Copyright © 2017 vBulletin Solutions, Inc. All rights reserved.