Hi,
Below are the requirements:
I would like to copy the data from my SQL tables to local access tables. (10000 records or so)
I CANNOT link the tables so that option rules out
I tried to create a pass through query with my ODBC connection (select ID,NAME from sqltable)
But then which is the fastest way to copy the data?
Is using the recordset the only option for me as I cant link the tables?
Can someone provide a query/template that I can work on?
Thanks!