Recordset Copy

[Guest]

Can anyone recommend the most optimized way to extract data from more than
one Access files to other Access file.

Currently I have more than 20 Access files, I need to execute their Queries
(all the same structure), Copy and then Paste to one Master Access file’s
Table.

 

[David Lloyd]

Lucotus:

You can use the IN syntax in a database query to reference a table or query
in another database.

For example:

INSERT INTO NewTable
Select * FROM QueryRemote IN C:\myremotedatabase.mdb

You could create a looping structure to loop through all of your Access
files, specifying their location, and executing the INSERT INTO query.


--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Can anyone recommend the most optimized way to extract data from more than
one Access files to other Access file.

Currently I have more than 20 Access files, I need to execute their Queries
(all the same structure), Copy and then Paste to one Master Access file's
Table.