I have an Excel sheet linked to Access 2007. This way when I update the Excel sheet, the queries in Access update automatically.
I have a problem with a field with date format in the Excel sheet. The query result in Access linked to this sheet, shows the value of the cell in numbers, that is the numbers that represent the date. In Excel for eg. 23/02/2006 is equivalent to 37309. My Access query shows 37309.
What can I do so that my Access database shows the field in date format?
Thank you for your help.
Bookmarks