SQL Insert gives syntax error but works in Query

C

Chris Nebinger

It appears to be a valid SQL line, other than possibly
adding a space between VALUES and (

Can you paste your code here so we can take a better look
at it?


Chris Nebinger

-----Original Message-----
INSERT INTO tblTicketPriorityHist (TicketID, Priority,
Click to expand...
When, User) VALUES( 2, '2', #4/22/2004 8:30:15
AM#, 'dcmcspar')
The above statement causes a syntax error when executing
Click to expand...
VBA but when I paste into a query it runs.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Insert gets syntax error but works in Query !?! 2
Syntax error using dlookup 4
Calling Parameterized Query Using SQL Syntax 3
type mismatch error in macro in excel 0
Syntax Error in Query Expression 2
SQL Syntax Problem 4
Buggy SQL Syntax for External File Path in Access 2007 8
Insert into syntax error 2

Top