I have a linked table set up in Access 2007. The cells in Excel are a number of date fields and are set as such. Issue is in Access the data (date) is being stored as a number. Common problem, however, I can't really find a solution anywhere - so thought I would come to my experts here for help. What is the best way for me to start seeing the date as a date format in Access?