Import data from DAO recordset to local table

[aflack]

Hello all, first of all i will have to state that i am not really a VBA person i am a little confused by this simple matter.

I have a MySQL server and am able to talk to it now via DAO. What i wanted to do is to be able to import a recordset from the MySQL server and store it in a local Access table, and also the inverse of that. I wanted to use DAO (or ADO if needed, but i dont know anything about ADO) to manage the MySQL data, and didnt want to link the tables in Access.

A simple solution would be opening both the tables in DAO and processing the recordset line by line, but i was looking for a faster smarter way using the SQL engine(s) to do the work as this solution would probabbly by way too slow.

If anyone could point me in the direction to do this i would be greatful.
Andy.

 

[KeithG]

You could create a Pass Through query to connect to the data and then Append it to your table. You will need to use an ODBC driver to connect to MySQL.

 

[aflack]

how would i go about appending it to my local table. Sorry but very rusty when it comes to VB, so really need things spelled out im afraid when its not the real basics.
Have not touched Access propperly in about 4-5 years.

Thanks.
Andy.