I am copying a series of columns from Excel Spreadsheets into an Access Data Table that is formatted as short date. The cell in Excel that contains the date is formatted as a simple date (*3/15/2005). When I copy the column and paste it into the Access database, the year changes to four years earlier. For example 6/3/2015 becomes 6/3/2011. I am using the MS Office Profession Plus 2010 verions (14.0.7153.5000 - 32 bit).
Why are the dates changing and how can I fix it? The Excel dates are correct.