INSERT with reserved name

[marsss]

One of my table have a field named "Date" which causing me some trouble when i try to create SQL query in my VBA code

since name is reserved, i do put the name between [], but it keep tell me i have to few value when i run the query

strSQL = "INSERT INTO tblDay (refSheet,[Date],Houre) VALUES (3,#2004-10-10#,0)"

but if i put that in a regulare query :

INSERT INTO tblDay (refSheet,[Date],Houre) VALUES (3,#2004-10-10#,0)

it work fine

Why my query called from VBA wont work...

 

[marsss]

Forgoet that... just see after couple trying to fix that the error msg was for anothing after the insert in my VBA code ayaye...

 

[marsss]

Edit: spelling heh

Forget that... just see after couple houres trying to fix that the error msg was for anothing after the insert in my VBA code ayaye...

 

[marsss]

Bleh, isn t my day..

try #3:


Forget that... just see after couple houres trying to fix that the error msg was for another thing after the insert in my VBA code ayaye...