Access Text Import Key Violation

  • Thread starter Thread starter TRB_NV
  • Start date Start date
T

TRB_NV

I've seen a lot of posts about this error, but still haven't seens the
answer on how to append text (comma delimited) data to an Access table.

I have field sales reps that have access on their laptops. Once a month
they email a text file with the new purchases they've made. The order
numbers are not the same as in the master copy of the database. Looking
through the code, it appears the data is appended and then compared. What
the database used to do was automatically assign new order numbers, based on
the next available order.

Would someone please explain step by step how I can do this?

Thanks
 
Need more specific info if you want a decent answer.

The genral idea woul dbe to import the text file into a staging table.
Then run code and queries to compare the staged data with the Main data.
Add new records and update existing ones.
You can pretty much assume the PKs are going to be different so you need
other key data like PO Number to do the comparisons.
 
Back
Top