Appending one row at a time

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

Guest

Is there any way in an append query to specify that you just want to append
one row at a time?
 
You can't interrupt a SQL statement with a prompt to confirm individual
record appends or updates. A SQL statement/query is a batch process.
 
This may be accomplished by using a for loop and a counter inside VBA.
Although, you would have to run the query from a Form. This would
allow you to also create a prompt or execute code between each record
that you are appending.
 
Back
Top