How Insert Access table data into mysql Table? 2

[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.

 

[Remou]

You can link to the MySQL table with ODBC or ADO and update, or simply update through ADO.

You will find connection strings here:

http://www.connectionstrings.com/mysql

 

[CharlesFS]

Remou can you post sample code? Please.

Thanks!

 

[CharlesFS]

SOLVED!!!!!!!!!!!!

My soluction to insert access table data into mysql table->
'******************************************
Sub INSERT()
DoCmd.SetWarnings False

strSql = "insert INTO [ODBC;DSN=Database;DATABASE=Base;_ Trusted_Connection=Yes;].TblDestiny select * FROM TblSource;"

DoCmd.RunSQL strSql

DoCmd.SetWarnings True
End Sub
'******************************************

Thanks Remou!

 

[Remou]

Excellent!