Hi folks
I am trying to export an access 2010 table to mysql DB. Any one has an idea how to get this done.
I created a DSN and tested it by dropping the table in MYSQL from an access query. This is how I dropped the table
Set wsAccess = DBEngine(0)
Set dbODBC = wsAccess.OpenDatabase(Application.CurrentProject.P ath & "\mydb1.accdb", , False, "ODBC;DATABASE=mydb1;DSN=myDSN")
DoCmd.RunSQL ("Drop Table from theTable")
This drops theTable from MYSQL
Now I want the transfer my local ACCESS 2010 table (which is also called theTable) to mySQL.
I thought about docmd.transfer method, but how do you make it pass through????
Thank you
Mike