trevorhartman
asked on
xls to mySQL
Hi,
I have two .xls documents that i want to import into a table in my mySQL database. What would be the quickest way to do this? I'm using phpMyAdmin 2.5.4
Thanks
Trevor
I have two .xls documents that i want to import into a table in my mySQL database. What would be the quickest way to do this? I'm using phpMyAdmin 2.5.4
Thanks
Trevor
There are many available tools for importing. EMS Mysql Quick Import - http://ems-hitech.com/quickimport is one of the good and easiest way. You have a fully functional trial version of 30 days.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Nodding draconius's way, I find it more reliable to save the excel data as Tab Delimited Text and import in the same manner.
Discuss?
Mike
Discuss?
Mike
I agree. In fact that's just what I said, but a bit shorter. :o)
ASKER
I ended up using the cvs and phpMyAdmin insert data from textfile. worked great
thanks - Trevor
thanks - Trevor