Vba Code to insert data from access table to mysql table

[charlesfs]

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.

[CreganTur]

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.

[stanl]

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