excel into mySQL

[webkocken]

I wonder if there's anyway i can import the data from a exceldocument to a mySQL database like u can import excel into access.

Does anybody know?

Perhaps it's possible to import it into access first and them import the data from access to mySQL?

[Khalid Ali]

from access to mysql will be a better idea,
in Access you have tools such as import or export external data,you can use them..

[PeOfEo]

yes, you might go from excel to access to mysql or vice versa and use access as a sort of midle man since it can export and import from all different types of data bases and spread sheets, more so then from excel.

[drsmartman]

You can use mysqldump to generate a delimited file for import. Keep in mind the limitation of Excel is something like 65000 rows. If you want to dynamically view MySQL tables through Excel (the "other way"), just download the MyODBC driver from mysql.com. Works like a charm!