Date Format questions while importing from Excel to Access

[mickeync]

Hi all,
I am running a problem while importing the spreadsheet which contain the date field from Excell 2000 to Access. I want the date field look just like in excel mm/dd/yyyy. However after importing, the date automatically change to mm/dd/yy. I must have 4 digit year as user requested. I know it's simple, but I only have few hours to complete. Any help would be greatly appreciated.

M.

 

[RobCPA]

Is this what you want to see when you open the table? If so, open the table in design view and go to the Format property and type in mm/yy/dddd and then save the table. You should then see the four digit year.

Rob