How can I schedule a macro to a make table to run during the nigh.

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

Guest

I use an ODBC connection to gather my data but it is too slow. I have used a
query to make a table instead but I need that data refresh during the night.
How can I automate this process?
 
I got the command figured out but the macro is set to run 5 make table
queries and it does not run. I tried other macros and they worked fine. Is
it because the make a table query prompts when deleting the tables? If so How
can I disable that "feature"?
Thanks, JM
 
Back
Top