MS Access: INSERT Date

INSERT INTO tb_test(Date, MyDate) VALUES('10/10/2000', '10/10/2000')

[askmaster]

Dear,

I use Perl to insert data to MS Access with "INSERT INTO tb_table(Date, myDate)VALUES('10/10/2000', '11/12/2001')

I got an error: Syntax error in INSERT INTO

I think "Date" is the keyword but I cannot change the field name (other developer developed forms and reports) Is there a way to solve it?

I don't want the statement "INSERT INTO tb_test('10/10/2000', '11/12/2001')" because the table has more than 40 fields and we may add more fields.

Thanks

[jatar_k]

Hey askmaster,

Did you find a solution to this yet?

I would imagine that is a reserved word, I think the best bet is to change the colname, if that isn't an option, you might be in a bad place.

Maybe someone else has a thought?