help VBA code in macro

  • Thread starter Thread starter Cam
  • Start date Start date
C

Cam

Hello,

I created 2 append queries to append data to a table called "Output" and
would like to help in creating a macro to first clear all the existing data
in "Output" table, then run the 2 queries. After data is appended to the
table, copy new data from Output table to either sheet1 of the "BSchedule"
Excel file or refresh the data by importing from the Excel file. Thanks
 
Cam said:
Hello,

I created 2 append queries to append data o a table called "Output" and
would like to help in creating a macro to first clear all the existing
data
in "Output" table, then run the 2 queries. After data is appended to the
table, copy new data from Output table to either sheet1 of the "BSchedule"
Excel file or refresh the data by importing from the Excel file. Thanks
Click to expand...
 
Back
Top