Run Multiple Queries on Many tables

[Anil]

We are likely to have about 900 tables.
Eg a query "append to BOM" has to be executed on various
tables for e.g. Product A, Product B, Product C, etc. and
add the data to "BOM" table.

Similarly there will be other queries that we will define
and these too have to run across all 900 tables and append
the data into other tables.

1) We would like to define the code/ query/ tool so that
these queries can be run and the query will look at all
the 900 tables and append the data


2) We would also also like to define a code/ query/ tool
that can run ALL the queries on the 900 tables at one
shot, it will be wonderful

 

[Anil]

Well I understand that a single table is better. Thats
exactly the reason to write the query. We have 900 excel
sheets that need to be merged into 1 table, so we are
importing these sheets in Access as seperate tables. Then
we want to create multiple tables from these sheet so that
further analysis and queries can be executed.

Anil

 

[Tom Ellison]

Dear Anil:

I would suggest you might try a function that links these spreadsheets one
at a time and imports the data. Linking them instead of importing them is
going to keep you from having 900 tables.

I do not see why you would "want to create multiple tables from these
sheet." You can perform any "analysis and queries" from the single table
into which you have placed all the records.