Hy, i need a vba code to insert all data from access table into mysql table.
I tryed "DoCmd.TransferDatabase acExport" but this send the table object to mysql.
Help please.
Hy, i need a vba code to insert all data from access table into mysql table.
I tryed "DoCmd.TransferDatabase acExport" but this send the table object to mysql.
Help please.
Welcome to the forum- always good to have new members.
I would suggest using an Append querry to insert the records from your Access DB to your MySQL table.I don't work with MySQL so I don't know the specifics of the procedure, but a little google-fu will serve you well.
-Randy Shea
I'm a programmer, but I'm also pro-grammar!
If your issue is resolved, please use Thread Tools to mark your thread as Solved!
PODA (Professional Office Developers Association) | Certifiable | MOS: Access 2003
you will find this handy
http://www.w3schools.com/SQL/sql_datatypes.asp
Are you using a Provider to connect to mySQL or just the ODBC Driver?
Stan