XL to MySQL

"How to?"

[henry0]

Hello,
A client gave me a couple of XL files with a ton and half rows!
How can I transform those data in MySQL format?
Thanks

Regards

Henry

[henry0]

I needed to perform that task like yesterday

I searched and found a good tool

FYI: excel to MySQL 2.1 - works great -

however if there is a way to do it via PHP
I would like to know about

Henry

<<
cost about as much as 15 US gals of gas!
>>

[lorax]

Are the files is native Excel format or in a comma delimited or CSV file format?

If the latter, then an import routine should be a snap to write though I'd hazard a guess that one exists already.

Do you have PHPMyAdmin installed? That would take care of it for you - providing they are comma or tab delimited text files.

[henry0]

I should have thought about it
Yes that the way to do it
files are native XL
but I may transform them in CSV files
then since I have PHP myAdmin installed I'll be in business

now I do not know if there is a routine available but I have done quite some search and found none.

thanks
Henry