J
Jonathan Scott via AccessMonster.com
I am currently working on an Access97 database application, and when I
export a table to an Excel spreadsheet, I find that my dates turn out as
other than I would expect or want.
For instance, "00/01/01" will sometimes be displayed "00/01/01", sometimes
as "01-Jan-00" or something similar.
What I need is a way to force ALL dates to be exported to spreadsheet
format in the format "YYYY/MM/DD". Is there a way to do this, efficiently?
Or perhaps I will have to recreate my table with the date fields as text
and put the dates in there as I expect them? (a rediculous idea considering
how wasteful and illogical it is)
Any help with learning to export to formats such as Word97 or Excel97, etc.
would be much appreciated.
TIA,
Jonathan Scott
export a table to an Excel spreadsheet, I find that my dates turn out as
other than I would expect or want.
For instance, "00/01/01" will sometimes be displayed "00/01/01", sometimes
as "01-Jan-00" or something similar.
What I need is a way to force ALL dates to be exported to spreadsheet
format in the format "YYYY/MM/DD". Is there a way to do this, efficiently?
Or perhaps I will have to recreate my table with the date fields as text
and put the dates in there as I expect them? (a rediculous idea considering
how wasteful and illogical it is)
Any help with learning to export to formats such as Word97 or Excel97, etc.
would be much appreciated.
TIA,
Jonathan Scott