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