sequential append queries

  • Thread starter Thread starter JR
  • Start date Start date
J

JR

I have to build a table using append queries once a
month. It takes 20 queries to build the table. Is there
a way to program the queries to run automatically one
after the other?
 
You can use a macro to run the queries. In the macro,
under action just select OpenQuery, and put the query name
in down below. Just keep listing them sequentially in
each line down and it will automatically run. If you do
not want to see the warning messages you can also turn
those off before the queries and then back on once
everything is done. To turn the warnings off select the
action SetWarnings and then choose Yes (turned on) or No
(turned off) below.

Jessica
 
Back
Top