L lhomme New member Local time Today, 13:35 Joined Feb 6, 2009 Messages 4 Feb 6, 2009 #1 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?
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 Wino Moderator Staff member Local time Today, 10:35 Joined Aug 30, 2003 Messages 36,272 Feb 6, 2009 #2 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 ...
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 ...