Appending one row at a time

G

Guest

Is there any way in an append query to specify that you just want to append
one row at a time?
 
D

Duane Hookom

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.
 
N

NathanJ

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.
 

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

Append Query Issue 0
Schedule Auto run Query on append table 0
append query 1
Access 2010 append query to SQL is very slow 0
How to append running number 1
Access 2007 - append query only appending 0 rows??? 0
Append Rows based on field value 2
Table not in List to Append to 3

Top