need to delete records

  • Thread starter Thread starter test guy
  • Start date Start date
T

test guy

I'm currently performing an AppendQuery take newly imported data from one
table, and append it to another table. I'd like to empty out the source
table after the append to make sure that its clear for the next import.
Anyone have a good way to do this? I'd probably like to put it into the
macro that calls to the AppendQuery (among other things)...
Thanks!
 
test guy, your right. Add a delete query to the macro,
just below the append query. Once you move the records
you can then delete them. Good luck. Mike
 
Back
Top