PDA

View Full Version : Vba Code to insert data from access table to mysql table



charlesfs
12-14-2008, 10:39 AM
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.

:banghead::help:motz2::banghead:

CreganTur
12-15-2008, 06:40 AM
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
12-21-2008, 04:43 AM
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