Data transfer between Access and MySQL

  • Thread starter Thread starter Chris Cusack
  • Start date Start date
C

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
 
Chris said:
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?
Click to expand...

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
 
Back
Top