I have the following insert statement
SQLStmt = "INSERT INTO SmartScreen_Items (Chart, Date, Name, [Control Type], [Load Order], Data)" & _
"Values ('" & sChart & "', '" & sDate & "', '" & sName & "', 0, " & sLoadOrder & "," & _
" '" & sData & "')"

I am getting a sytax error on this statement. I have checked the Table it has exactly the same fields and also all are text fields except the Control type and load order.

Thanx

Suggest you do the usual debug just after that line:

Response.Write SQLStmt
Response.End

That will show you the actual SQL that is going to be executed. Look out for (e.g.):

INSERT... Values ('A','B',,'D')

(two commas in a row)

I think "Date" is a reserved word......try using [Date]

Thanks a bunch!

If that didn't work, I did notice you don't have a space after the end of the first set of () - it just goes ")values". It shoud be ") values" no?