C
ChuckTX
I'm trying to write a query that will do a Union of all of the tables with a
certain naming convention (that start with CL_ or something like that). I
would like this to be run automatically when a query is called. I was hoping
not to have to open Access. This query will hopefully be called from an Excel
file import call. The tables will be linked Excel files. I would like to
build the query so that if a new table is added or one is dropped that would
automatically be accounted for in the query the next time it was run. All of
the tables will have the exacyt same columns but the data is to be stored as
a separate file for each case. I know there are so many better ways to do
this if all the data was in Access, but that's not the way they want it.
Also ideally the data would never be stored in Access, just passed through.
Thanks, Chuck
certain naming convention (that start with CL_ or something like that). I
would like this to be run automatically when a query is called. I was hoping
not to have to open Access. This query will hopefully be called from an Excel
file import call. The tables will be linked Excel files. I would like to
build the query so that if a new table is added or one is dropped that would
automatically be accounted for in the query the next time it was run. All of
the tables will have the exacyt same columns but the data is to be stored as
a separate file for each case. I know there are so many better ways to do
this if all the data was in Access, but that's not the way they want it.
Also ideally the data would never be stored in Access, just passed through.
Thanks, Chuck