S
S Davis
Hello,
Is there any way to create a query in access such that when imported
through the use of MS-Query in excel, it comes in as a recognized date
and not text?
I have tried FormatDateTime ([Column],2) and Format
([Column],"d-Mmm-YYYY"). Both return acceptable visual representation
of my data, but are seen as text in excel and are preventing me from
Grouping my pivottable data.
Thanks
-Sean
Is there any way to create a query in access such that when imported
through the use of MS-Query in excel, it comes in as a recognized date
and not text?
I have tried FormatDateTime ([Column],2) and Format
([Column],"d-Mmm-YYYY"). Both return acceptable visual representation
of my data, but are seen as text in excel and are preventing me from
Grouping my pivottable data.
Thanks
-Sean