How to import date format from Excel to Access?


Posted by Donna on November 20, 2000 6:07 AM

We have a spreadsheet that we are trying to import into
Access. It works fine except cells that were entered in
date format. The numeric value (36850 instead of 11/20/00)
is what gets imported into Access. Changing the format
from date to text in Excel changes the value to the
date numeric value. Is there someway to convert the date
to text and have it display in date format: 11/20/00?
Or some way to convert those numeric values to date
format in Access? Any suggestions or help appreciated.



Posted by Greg on November 20, 2000 7:17 PM

Response: If you put an apostrophe in front of the date in Excel it shows up as text. I am not quite sure exactly how it imports, but you might try that.