Copy data from SQL to local Access Table

[usertest]

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!

[June7]

If you can make pass-through query work, use the PTQ as source for an INSERT INTO SELECT or SELECT INTO action.

[usertest]

OK so what I understand is, in the PTQ, use the below query to add the data, right?

select * into localTable from dbo_serverTable

If you can make pass-through query work, use the PTQ as source for an INSERT INTO SELECT or SELECT INTO action.

[June7]

Not in the PTQ. The PTQ would just be a SELECT to pull data. Then, an Access query refers to the PTQ as source just as it would any table or query.

[usertest]

That worked. Thanks!

Not in the PTQ. The PTQ would just be a SELECT to pull data. Then, an Access query refers to the PTQ as source just as it would any table or query.