importing and appending results of queries from different db in one db

Posted by user316833 on Stack Overflow See other posts from Stack Overflow or by user316833
Published on 2010-04-14T18:42:20Z Indexed on 2010/04/14 18:43 UTC
Read the original article Hit count: 187

Filed under:
|

I have 1000+ access files. Each file has a query named "overview" that has the same fields in each of the 1000 files. I need to import the results of these 1000+ overview queries into one single access db and append them into one table. Is there an automated way to do this? Thanks very much.

© Stack Overflow or respective owner

Related posts about import

Related posts about append