Copy a Recordset

[cable]

I've got data sources as text files and on SQL server databases and I want to store a copy of the data used during the run of the program in an access db. The text files are easy enough, but the sql, well having a bit of a mental block on this:

I'm opening a recordset on a SQL server ok, but I now need to copy the results to a new table in the access db.

Whats the best way to this? So far I can only come up with 'loop through the rs' !!! now that can't be right

 

[namliam]

If you have an ODBC-passthrough query you can build a create table or append query on top of it. If you are building the connection yourself you will have to loop ... no other option...

Regards

 

[cable]

If you have an ODBC-passthrough query you can build a create table or append query on top of it.

How would I know if I have one of them? or how would I create one of them, the SQL will be fairly simple select's if that makes a difference.

thanks