Return list of records that fail to append?

[terdfurgeson]

I've searched the internet for about 2 hours now without success. Hopefully I've just been using the wrong search terms.



In short, I want to know which records fail to append based on violating the primary key. (Win 7, Access 2010 32bit) Similar to how Access creates import table errors, but for append violations...

Is this something anyone might have a solution to do? The DB takes a daily data dump. Failures to append (in this DB) indicate a status of "complete" that needs to be re-examined. (A true complete will not be present in the daily file). The daily file also contains all new daily work, thus it isn't just a list of "completed" tasks to re-examine.

[June7]

Not if you are using the import wizard. What method is used to import the records?

Where does data come from - Excel, CSV, another db app?

Can you set a link to the source?

[terdfurgeson]

Thanks for the quick answer.

Import is done via VBA:
DoCmd.TransferText acImportDelim, "ImportSpec2", "Data", OutputLocation & "DB File to Import for " & dte & ".csv", True

Warnings are suppressed as I don't need it telling me there are key violations if I don't see them

The data comes daily in a large excel file. I manipulate this down to the relevant parts for me, then import the CSV. I hadn't though of linking to it, but I'd prefer one single data file if I can make it happen that way.

Maybe getting out of the office will clear my head and I'll think better tomorrow....

[June7]

So maybe set a link to the file then use the link like a table in query to find the duplicate key records.