MS Access append query to SQL Server table. SQL Table is blank but does have identity column.
When I run the SET IDENTITY_INSERT [Table] ON;
I try to run the Append Query in MS Access, but get a Key Violation.
If I wait X minutes then run the same Append Query again, it adds the records.
I am wanting to speed this process up as I have many tables to work on.
What is the best way to do this?
SQL Server 2012 R2