Question Issue Importing Dates from Excel to Access

[dugoneill]

I searched and found other issues with importing Dates, but none addressed the issue I am having.

I am importing an Excel 2007 worksheet into Access 2007 via Access - External Data - Excel

My spreadsheet, Access, and Regional setting are all for US.

The date in the spreadsheet is in mm/dd/yyyy format

In the spreadsheet the date of 3/24/2000 gets imported into Access as 3/23/1996, and this same pattern holds true for every date (1 day and 4 years earlier)

 

[David Eagar]

What are the regional settings in the control panel of the computer?

 

[alktrigger]

What if you create an extra column next to the date column and set it equal to the date column, then format it as "General" so that it shows the 5 digit date code
i.e. 3/24/2000 displays as 36609
Import the date codes into a temporary table as "long" data type, and then transfer to its final table using the CDate() command.

 

[dugoneill]

What are the regional settings in the control panel of the computer?

USA mm/dd/yyyy

 

[dugoneill]

What if you create an extra column next to the date column and set it equal to the date column, then format it as "General" so that it shows the 5 digit date code
i.e. 3/24/2000 displays as 36609
Import the date codes into a temporary table as "long" data type, and then transfer to its final table using the CDate() command.

3/24/2000 displays as 35147