I am using an append query. I am getting a data type mismatch in criteria expression. Hard to understand how, since I copied the table? I have field to field matched. SQL reads
INSERT INTO [Copy Of Employees] ( SocialSecurityNumber, FirstName, LastName, EmployeeID, Address, City, State, PostalCode, HomePhone, CellPhone, Birthdate )
SELECT Employees.SocialSecurityNumber, Employees.FirstName, Employees.LastName, Employees.EmployeeID, Employees.Address, Employees.City, Employees.State, Employees.PostalCode, Employees.HomePhone, Employees.CellPhone, Employees.Birthdate
FROM Employees;
I did a little test and ran the append query, with the EmployeeID and that did not have any data type mismatch. So I am assuming the error is generated because EmployeeID is a number in the Employee table and a autonumber in the Copy Of Employee table. I deleted the table out and copied the structure again. This time I made sure that no field was set to be the primary key. Still the same error message. Any work arounds?