insert procedure error message

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an access 2000 database (with the adp extension, so it's actually a
SQL database) and I'm am trying to "append" data from a view to a table.
Both have the same number of fields, each are the same field types, however
the following Procedure says bad things about the proc ADO error: Incorrect
syntax near the keyword 'INSERT'.

Create Procedure "ProcName"

INSERT "tablename" (field_1, field_2, field_3)
SELECT field_1, field_2, field_3
FROM "viewname"

Help
 
Are you actually using double quotes round the names of the table and
view? That produces syntax errors in Jet SQL.
 
no quote marks. Same statement without the Create Procedure line works in
SQL Query Analyser.
 
Isn't there some sort of terminator needed between the CREATE PROCEDURE
statement and what in another language would be the body of the
procedure? Like AS? You'd better check in BOL or MSDN: they're a far
better source of SQL Server information than I am.
 
Yep the AS word was needed. Thanks

John Nurick said:
Isn't there some sort of terminator needed between the CREATE PROCEDURE
statement and what in another language would be the body of the
procedure? Like AS? You'd better check in BOL or MSDN: they're a far
better source of SQL Server information than I am.
Click to expand...
 
Back
Top