Access Insert failing, but no error message
tamara.l.larsen_at_wellsfargo.com
Date: 09/03/04
- Next message: Shep: "How do I import data from access into a power point presentation"
- Previous message: Bill Stanley: "Transfer from external Microsoft Access 2000 database"
- Next in thread: Joe Fallon: "Re: Access Insert failing, but no error message"
- Reply: Joe Fallon: "Re: Access Insert failing, but no error message"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 3 Sep 2004 13:15:19 -0700
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?
- Next message: Shep: "How do I import data from access into a power point presentation"
- Previous message: Bill Stanley: "Transfer from external Microsoft Access 2000 database"
- Next in thread: Joe Fallon: "Re: Access Insert failing, but no error message"
- Reply: Joe Fallon: "Re: Access Insert failing, but no error message"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
