Expected end /msaccess/ insert into

[odbcmsaccess]

i'm trying to insert data using INSERT INTO
ERROR: Expected end of statement

sSQL = "INSERT INTO AssesseeProfile1 ( NameoftheAssessee ,&_ PINCODE5, TELEPHONE5, STD5, FAX5, E - MAILID5, PAN, " ) VALUES "& _
"(' " & STD5 & " ', ' " & FAX5 & "', '" & EMAILID5 & "', '" & PAN & "')" 'Set our SQL query
conConnector.Execute (sSQL) 'Execute this SQL query
conConnector.Close
Set conConnector = Nothing
plz give me solution as early as possible

[nico5038]

Hmm, your stringing fails on multiple points, try:

sSQL = "INSERT INTO AssesseeProfile1 (STD5, FAX5, [E - MAILID5], PAN ) VALUES "& _
"('" & STD5 & "', '" & FAX5 & "', '" & EMAILID5 & "', '" & PAN & "')" 'Set our SQL query

The fields "NameoftheAssessee ,&_ PINCODE5, TELEPHONE5, " aren't part of the VALUES clause so I've removed them and also the "after the PAN of the fieldlist as that's no fieldname...
When a fieldname has spaces you need to use brackets like: [E - MAILID5]
Better however not to use spaces nor minus signs in fieldnames.

Nic;o)