date insert question for access and vba

[Bastien]

I'm reading in a bunch of variables from a text file and having problems with the insert statement...if there is a date field and no data in the text file, do i still need to have # sign in the sql?

that is

sql="insert into mytable(id, adate) values (id, ##)

TIA
Bastien

There are many ways to skin this cat,
but it still tastes like chicken

 

[Bastien]

use nulls for empty values Bastien

There are many ways to skin this cat,
but it still tastes like chicken