Converting excel to mysql [Archive]

Repair Bad Credit | Advertising | Proxy | Credit Card | Problem Mortgage

Converting excel to mysql [Archive] - ZGeek

View Full Version : Converting excel to mysql

Pirate

26-08-2005, 11:40 AM

I have a bunch of excel files that I need to convert into a database. I know I can enter the data using queries, but I have around half a million records to insert. Plus I'm still a n00b at this.

Anyone got any suggestions on how to do this?

tomsyman

26-08-2005, 11:47 AM

Just sent you an email with a macro my IT guys wrote for me to take data out of a spreadsheet and put into a database. If you can decifer it go right ahead and use it!

Pirate

26-08-2005, 11:55 AM

thanks heaps man, i'll check it out.

Enthalpy

26-08-2005, 06:13 PM

PHP can read directly from the Excel files.

I've used a commercial class to do so on Linux, however given that quite some time has passed since that was bleeding edge there are now a few alternatives that are free.

See :

http://www.experts-exchange.com/Web/Web_Languages/PHP/PHP_Windows/Q_21061888.html

HTH

edit: assuming you want to manipulate the data before shoving into MySQL.