Query on multiple linked tables

[lhomme]

I have a set of multiple CSV tables linked to an Access database. (There are dozens of almost 2GB sized files.) Is there a way to run a query on all of them (or sets of them) as one gigantic table?

 

[pbaldy]

I don't know what the performance will be like, but try a UNION query:

SELECT Field1, Field2
FROM Table1
UNION ALL
SELECT Field1, Field2
FROM Table2
UNION ALL
...