Data transfer between Access and MySQL

[Chris Cusack]

Has anyone organised a data transfer from a client computer running Access
to MySQL tables located on the web ISP server? Is this possible? Are there
indirect ways around it?

chris

 

[Philipp Stiefel]

Has anyone organised a data transfer from a client computer running Access
to MySQL tables located on the web ISP server? Is this possible? Are there
indirect ways around it?

If you want to upsize your whole Access database
and transfer your complete data to web server once,
the best way to do that is by exporting the data to
a textfile, uploading the textfile and importing the
textfile to the MySQL database.

There are ready-to-use VBA modules, that enable you to
dump your whole Access database to a SQL-Script for
MySQL. e.g.: http://www.cynergi.net/exportsql/

HTH
Phil