Data transfer

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

Guest

I want to transfer data filtered by a query from Table 1 to Table 2 and
delete it from Table 1 how do I do this using a macro? Thank you for the
assistance.
 
1. create the queries that do what you want
2. run them , in sequence, from a macro
3. You may want to setwarnings = false before those queries

Bob
 
I tried to set up the Macro however it did not work. I did something wrong.
Can you tell me the steps for seting up the Macro:
Setwarnings "No"
Openquery...ect.

Thank you
 
Back
Top