Above is the error I am receiving when trying to insert new records based off an unmatched query. I believe this is due to having the Identity Specification set to "yes" on the table. This is the first time I have run into this and most of my searches have only returned how to fix this on the server side rather than the Access side.
For the record, here is the query I am trying to run. All I did was load a refreshed Excel sheet and use the wizard to create an unmatched query that I am now trying to append to the SQL Server table.
SQL:
INSERT INTO tblCustomers ( [Account #], [Customer ID], [Customer Name], [Account Status], [Outside Sales #], [Inside Sales #], [SIC Code], Prefix, [Customer Type], JobID )
SELECT [Sheet1 Without Matching tblCustomers].[Account #], [Sheet1 Without Matching tblCustomers].[Customer ID], [Sheet1 Without Matching tblCustomers].[Customer Name], [Sheet1 Without Matching tblCustomers].[Account Status], [Sheet1 Without Matching tblCustomers].[Outside Sales #], [Sheet1 Without Matching tblCustomers].[Inside Sales #], [Sheet1 Without Matching tblCustomers].[SIC Code], [Sheet1 Without Matching tblCustomers].Prefix, [Sheet1 Without Matching tblCustomers].[Customer Type], [Sheet1 Without Matching tblCustomers].JobID
FROM [Sheet1 Without Matching tblCustomers];