This has not been possible to date but I will get back to
you after I recreate the ACCESS .csv export with actual
data. Unfortunately I do not have the actual export with
me and do not remember the format ACCESS is exporting out
the date-time in the csv file.
Thank you for such a quick response!
-----Original Message-----
It seems to me that if the dates in the Access generated
CSV were formatted
in m/d/yyyy format you wouldn't run into the problem.
Excel would translate
the date-like text into actual Excel dates, then you
wouldn't need any kind
of macro.
Is there a reason that can't be done?
Regards,
Ron
.
|