Prompt for table to be run in query

[cmany]

I am needing to be able to prompt the user the select a table to use in a query. Data will be imported via excel monthly, and the queries to separate the data into separate tables will need to be adjusted to accommodate the newly imported table.

So there is a July table with customer, order and product information, which all needs to be separated. The queries to do this will be the same each month, I just need to change the table in each query quickly.

It has been a number of years since having to do anything like this, and things are far different from what they used to be.

Is there a simple solution that I just may not be seeing???

[ranman256]

you shouldnt be asking for tables. All the data should be in 1 table and you prompt for what date.

[ssanfu]

<snip> So there is a July table with customer, order and product information, which all needs to be separated. The queries to do this will be the same each month, I just need to change the table in each query quickly.
<snip>

These statements indicate to me that you do not have a normalized table design/structure.

Maybe you could explain more about what the business is/does. Post a jpg of the table relationships/structures.

Having a table for each month of the year would be next to impossible to design forms and reports.

[davegri]

Need details.
So each month the import routine creates tables in an access db. The created tables have different names each month.
The newly imported table records need to be added via append queries to existing permanent tables in the DB.
The problem is adjusting the queries to accommodate the new input table names each month.
Any other special cases, requirements, pitfalls?

OK. How are you modifying the queries now? How are you running the queries now? How many queries are involved?
How do you envision the automated solution to work? With a form to enter the table names and a button to fire off the queries, or what?
Have you considered renaming the newly imported tables to a constant name so that the queries don't need modification each month?