Import Excel Sheet Date Format Problem

[randolphoralph]

I have a excel spreadsheet with a header row and 8 columns

Column A-C are set to text format
Column D is set to Date format (3/14/2001)
Column F is text format
Column G & H are set to Date format (3/14/2001)

When I try to import this into a new table it changes the date to a 5 digit number (Ex. 39780)

I am not sure what I am doing wrong and have tried several different formats to fix this and nothing seems to be working.

Anyone have any advice?

 

[The_Doc_Man]

That five-digit number is the internalized date format for Date fields. The import did the right thing. It just looks funny.

Your problem isn't as bad as you might first think. All you need to do is query that field using a Format$() function, which you can look up with Access Help. Choose one of the standard date formats. It will translate just fine.

 

[fkegley]

You could also change the type of the field in the Access database to Date/Time. Then set the format properties as you wish.