[AccessD] Import Excel Dates into Access

Mitsules, Mark Mark.Mitsules at ngc.com
Tue Oct 14 14:07:29 CDT 2003


I just received an Excel spreadsheet with a date column.  The dates display
as "8/22/2003", however the cell contains "8/22/2003  2:00:00 PM".  How can
I import this data into Access retaining only the date "8/22/2003"?  Prior
to this submittal I could link to the spreadsheet and copy/paste the records
with no massaging of data required.  They obviously have changed their
export routine.


Mark


More information about the AccessD mailing list