p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   SQL Server 2000 (http://p2p.wrox.com/forumdisplay.php?f=20)
-   -   append to a query - from access to SQL server (http://p2p.wrox.com/showthread.php?t=30460)

p2ptolu June 15th, 2005 08:23 AM

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]));

[u]Error message</u>
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.

All times are GMT -4. The time now is 07:21 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.