What is the problem with this query

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

Guest

I have the following query generated from a asp page, which uses access as
the back end.

Now, I am inserting the query in the sql view and trying to run it. At this
point, it
gives me syntax error. Not sure where the problem is. Any help is
appreciated in advance.

INSERT INTO tblExpense (ENO, Date, ContractedServiceExpense, TravelExpense,
PersonnelExpense) VALUES('1', '03/30/2005', '10', '5', '10')
 
I expect your use of single quotes as delimiters for all values is the
issue. Numeric fields don't use any delimiters and date fields use "#".
 
Back
Top