Access Insert failing, but no error message

  • Thread starter Thread starter tamara.l.larsen
  • Start date Start date
T

tamara.l.larsen

I am using Access to extract data from a SQL Server table
and load it into Teradata. This code was working
previously.

I have about 99,000 rows to insert. The query comes back
with the Append message and the correct number of rows. It
then returns a warning message that 211 rows won't be
loaded because of unique key constraints. But NONE of the
rows load and there is no Error message.

I am not worried about the 211 rows. Why won't the other
99,000 rows load?
 
Probably because it is in a Transaction and is rolled back.

There is something wrong with the data.
It is not something obvious like you failed to use the PK/
It is subtle. Perhaps an invalid date is in a field that expects a real
date.
Run a query and sort your Date data and see if there is anything "funny"
near the highest and lowest values.
 
Back
Top