I am trying to export some values from a table in my database to a text file then have these values imported and apprnded to another copy of the same database table the same table in another location
When I tried to Import the values I got an error stating that X record have been lost due to a key violation. I suspected that I was trying to put values to a auto number field and hence the error occured.
I then created a query that exported all other fields but the primayrkey autonumber field. To this action i also get an error stating that I cannot record changes because the value entered violates settings defined for the table or set.
I am working in access 2007
I do hope that there is a way to import what I Exported and append directly to a table as I want to be able to execuit the emport process with just one mouse click.
This post is connect to the project as describe in my previous post at Automating Data export and import in Access