K
kiln
DoCmd.OutputTo acOutputForm, Me.Name, acFormatXLS etc
works fine, but the date fields come over as some data type that sorts
as text. I can't find a way for format the xls to get it to sort
properly. I don't see any way to alter params for OutputTo
acOutputForm..that date fields are date data type. Access and Excel
2000.
What's odd to be about excel is that all of the dates look 100% legit:
9/19/2005
9/2/2005
and of course that's the sort order I don't want. But if type in values
from scratch like those, they sort like dates. Is there a way to force
excel to see this data as date values?
works fine, but the date fields come over as some data type that sorts
as text. I can't find a way for format the xls to get it to sort
properly. I don't see any way to alter params for OutputTo
acOutputForm..that date fields are date data type. Access and Excel
2000.
What's odd to be about excel is that all of the dates look 100% legit:
9/19/2005
9/2/2005
and of course that's the sort order I don't want. But if type in values
from scratch like those, they sort like dates. Is there a way to force
excel to see this data as date values?