Sub test() For Words = 1 To 5 INSERT INTO test SELECT * FROM NewCustomers; Next Words End Sub
R ria Oct 12, 2004 #1 Sub test() For Words = 1 To 5 INSERT INTO test SELECT * FROM NewCustomers; Next Words End Sub
M Michel Walsh Oct 13, 2004 #2 Hi, CurrentDb.Execute "INSERT INTO .. . ", dbFailOnError Hoping it may help, Vanderghast, Access MVP
