Checked number of solutions, however solution for below is ilusive to me!!!
Microsoft JET Database Engine (0x80040E14)
Syntax error in INSERT INTO statement.
/newshakti/careermap_adddata.asp, line 50
Line 50 is the last line of code:
SQL="insert into calendar_data(ddate,dtime,location,code,technology,level,description,status,mailto,subject)values('" & tdate & "','" & ttime & "','" & tlocation & "','" & tcode & "','" & ttechnology & "','" & tlevel & "','" & tdescription & "','" & tstatus & "','" & tmailto & "','" & tsubject & "')"
cn.Execute SQL
All the variables are defined and no spelling errors!!!
Any help would be much appreciated.