append to a query - from access to SQL server
I used this in Access and after i migrated to SQL this would not work as an append query which it was in access before upsizing, please how do i resolve this , it displays the error below the
INSERT INTO AuditUpdate ( TypeId, ElementSectionId, ElementTypeId, ElementId, ElementTitle, UserId, TimeUpdate )
VALUES ([TypeId], [ElementSectionId], [ElementTypeId], [ElementId], [ElementTitle], [UserId], CDate([TimeUpdate]));
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]The name 'TypeId' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.