MySQL & Excel

[gobbles]

I was just wondering .. What would be the easiest way to dump a XLS ( Microsoft Excel ) database into a MySQL database?

[kevinsequeira]

1. convert excel to access database
2. export acces databse to mysql using myodbc driver available at
   http://www.mysql.com/downloads/api-myodbc-3.51.html

let me know if u need more specifics

reg
kevin

[gobbles]

Since this is not hosted on my own servers ... Do i have to get the admin at the hosting company to install it on there servers .. Or can i just run it myself?

[kevinsequeira]

download the driver and install on your local machine

u should be able to connect to the mysql database from your machine directly. because in essence your transfering the access database on your machine to the mysql database on the other machine.

this article may help you out

http://www.devarticles.com/art/1/307


reg
kevin

[gobbles]

Thanks for your help kevin ... I might be able to get something done finally