Access Insert failing, but no error message

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tamara.l.larsen@wellsfargo.com - 03 Sep 2004 21:15 GMT

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?

Reply to this Message

Joe Fallon - 04 Sep 2004 03:22 GMT

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.

Signature

Joe Fallon
Access MVP

>I am using Access to extract data from a SQL Server table
> and load it into Teradata. This code was working
[quoted text clipped - 8 lines]
> I am not worried about the 211 rows. Why won't the other
> 99,000 rows load?

Reply to this Message