Import excel data script into mySQL?

[ballhogjoni]

Does anyone know of a script(way) to import an excel file into mysql?

[Barand]

Easiest is save as CSV then use MySql LOAD DATA INFILE

[lessthanthree]

If your server is a Windows machine running > PHP5.0, you can use a .xls workbook directly by loading it as a COM object.

 

Something like:

$excel_app  =  new  COM("Excel.application");

 

You can then do what you want with the data, check the PHP manual for full info here

 

However, as it's unlikely your server is running Windows and doing this will make your code extremely unportable (only ever going to work on a Windows box, which lets face it, aren't all that common in the PHP world) I suggest you follow the advice above and export the files as CSV, which not only is more portable, but far far easier to manipulate/get into MySQL.

 

Just though I'd let you and anyone else that may want to try it, that it is actually possible to work directly with a .xls (and other) file type.

[Barand]

If I use the COM method on my PC it works fine. If I try it on the network web server, also Windows, it doesn't.

 

I assume the difference is that my PC has Excel application and the network server does not.

 

 

http://web.informbank.com/articles/technology/php-office-documents.htm

[The Little Guy]

http://www.rietta.com/sqlconverter/

[lessthanthree]

If I use the COM method on my PC it works fine. If I try it on the network web server, also Windows, it doesn't.

 

I assume the difference is that my PC has Excel application and the network server does not.

 

 

http://web.informbank.com/articles/technology/php-office-documents.htm

 

Quite possibly you have to have some installation of Excel on the machine you're attempting to run the COM code on. My mistake, hadn't thought of that, thanks for pointing it out!

[ballhogjoni]

I am actually just looking to code a script to upload a csv, xls, etc... so I can manipulate the data before it is stored in my DB. I am running php 4 and mysql 4 ( I think ).