syntax error in query experession

[veer]

Hi
i am running a date query

squery = "Insert into " & txttablename & " IN '" & txtdatabase & " ' select * from " & sTableName & " IN '" & txtfolderpath & "\" & sArrFolder(icou nt) & "\" & sDirFolder & " ' where Yp1VStartTime <= " & DTPstart & " and YP1VEndTime >= " & DTPEnd & " "


but it is showing this error i,e
syntax error (missing operator ) in query expression Yp1VStartTime <= 4/14/2008 2:30:00 PM and YP1VEndTime >= 4/14/2008 10:00:00 PM

please check my query and give some idea
pleasssssssssse
varinder

[debasisdas]

is that an SQL ?

i don't think so.

[veer]

Hi
i am accessing access table data from vb 6.0
thanks

is that an SQL ?

i don't think so.

[debasisdas]

You need to learn SQL before trying to execute them from VB.

Learn the basics of SQL first.

[lotus18]

Hi
i am accessing access table data from vb 6.0
thanks

Debasisdas is right. You need to check your query first. BTW, what are you trying to achive? P.S. use code tags.

Rey Sean