Forum Moderators: coopster

Message Too Old, No Replies

XL to MySQL

"How to?"

         

henry0

11:17 pm on Feb 14, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



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

1:53 pm on Feb 15, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



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

2:56 pm on Feb 15, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



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

3:31 pm on Feb 15, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



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