[SOLVED] SELECT INTO with Identity - getting error
I'm getting an error (Undefined function 'IDENTITY' in expression) when trying to run this line:
Also tried COUNTER, same error.
What am I missing?
I'm getting an error (Undefined function 'IDENTITY' in expression) when trying to run this line:
Code:
strSQL = "SELECT newID = IDENTITY(1, 1), Data.Company, Data.Title, Data.Fullname INTO [Data Export] FROM Data ORDER BY Data.ID"
Also tried COUNTER, same error.
What am I missing?
Last edited: