Create a new table each time...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to have a query create a new table each time it runs without
having to interact with it?

For example: I set up a macro to automatically run the "export" query each
day at 10am and want to have it run again tomorrow without overwriting the
table.

Any examples would be greatly appreciated.
 
I'm confused...

You can export the results of a query without creating a table. Are you
using a Make Table query? If so, why?


Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Because my boss told me to... ;0)

Yes make table query. I am open to exporting the data as long as we could do
it daily as different files automated.
 
Because my boss told me to... ;0)

Yes make table query. I am open to exporting the data as long as we could do
it daily as different files automated.
Click to expand...

Export the query instead of the table. Just use a function to
determine the date range you want. You can use TransferSpreadsheet
and that should do what you want.
 
Back
Top