Inserting Data to Access Table (Local) from MySQL table (Net)

[gambit1430]

Guys,



Just want to ask how is the right way in appending data from a table in mysql to my local ms access table.
based on my research, i must us "Insert Into...In" statement..however i dont know where to start and how.

thanks in advance

[ranman256]

yes , build an append query.
If you are an Access beginner, use the query wizard.
It will ask you where to get the data, where to put the data.
Then you just run the query anytime you want to bring in data.

[gambit1430]

ranman256,

by just linking mysql table in msaccess via ODBC...i can easily create append query...however i was experiencing error.
when i run the query..i think it has to say with the connection issues...i think i need to use VBA here..
any sample out there?

thanks