i m using the access database and i m importing the data form the excel sheet and send it to the access. in the access database i want to insert the date which is in the string format.

Here is my code i dont know what is the probelm

do While NOT ExcelRS.EOF
'SDate = ExcelRS(0)
'SDate = Day(SDate)
'SDate = Month(SDate)&"/"& SDate
'SDate = SDate &"/"& year(SDate)
'SDate = CDate(SDate)
SDate = ExcelRs(0)
'response.Write(SDate)
'Response.End()
'insert1 = "INSERT INTO surya (SDate) VALUES (#01/03/05#)"
insert = "INSERT INTO surya (SDate) VALUES ("& SDate &")"
'response.Write(insert1)
'"&SDate&"
'response.Write(insert)
'response.End()
objConn.Execute(insert)
ExcelRS.MoveNext
loop

when i run this code it through the error syntax error in insert statement


help me please


$urya

insert = "INSERT INTO surya (SDate) VALUES ("& SDate &")"

correct:

insert = "INSERT INTO surya (SDate) VALUES ('"& SDate &"')"