INSERT Statement Help

[fertileverve]

Hello,

I have written a web application in ASP to insert data into a Microsoft
Access database. However, whenever I run the script, I get an error
"Syntax error in INSERT INTO statement".

Here is the INSERT statement:
INSERT INTO classes
(departmentid,instructorid,timetableid,course,title,credits,breadth,iden,section,comments,days,room,final)
VALUES (1,0,5,'ANT 102 [CV]','ARCHAEOLOGY AND PREHIST.
WORLD',3,'SS',3372,'LEC B371','9:00-9:50AM','MWF','A159','TBA')

I have gone over this and over this and can not determine what the
synatx error is.Number fields: departmentid, instructorid, timetableid,
credits, and iden. The rest are text fields.

I can take this exact insert statement and run it in access with no
issues. Please help.

 

[Van T. Dinh]

The SQL looks fine from Access / JET point of view. However, as you have
identified, the problem lies in the ASP side so I would suggest you re-post
this question to one of the appropriate newsgroups for ASP rather than here.
Most people here know about Access / JET and probably a few know ASP but you
cannot rely on "a few" and you have much better chance in an ASP newsgroup.

HTH
Van T. Dinh
MVP (Access)