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.
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.