need to delete records

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!
 
M

Mike

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to empty a table? 0
Importing Excel Data and Comparing to Existing Data Records 4
Appending records to new table using field names as values 2
Copy selected records from two tables to two new tables 2
Code to cut a paragraph that's followed by a table 2
best way to update table 2
Macro Performance 5
query field names changing to expr#: 8

Top