=now() not working in default value

[odun]

Hello all,

I have a table in access and one of the fields (date) has a default value of =now().

I have an excel spreadsheet that has all the fields in the access table inlcuding the date column (but the column is not populated).

When I import the spreadsheet into access, I get some errors...violations...when I open up the table, it does not have the date field populated, do you know why?

Thanks for your help.

 

[Vassago]

What is the data type of the field in excel and Access. Do they match? You do realize that even if you successfully allow it to import to the table, the date field will not be filled in because in Excel it already has a value of null, which will override your default value in Access.