Help VBA in macro

[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

 

[Alex Dybenko]

Hi,
you can create a new delete query, which will delete all records in your
Output table, and run this query (openquery) in your macro

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com