I am sure I must be doing something wrong but here it is:
I import an excel spreadsheet that has dates in the format mm/dd/yyy.
The receiving table in access has a date field set to mm/dd/yy, which
is what I want. The dates are now displayed with a two digit year. The
problem comes when I export the results to excel. When I open the
spreadsheet the dates are back to mm/dd/yyyy again!
Can I force excel to obey me? and keep the dates in mm/dd/yy format?
Perhaps by some workaround to change the field to text or something
before the export?
Thanks in advance for any assistance.
Neil
Bookmarks