M
microfich
I am trying to export a date column (and others) in a table to the
dd-mmm-yyyy format. When I use the Format function in a Make Table query,
the subsequent wizard option to 'Save Format' is checked and grayed out.
The resulting txt file shows the correct format for the date but contains
other formatting I cannot use (field names, fixed length fields, a row of
dashes between data rows.) I need just a pipe-delimited file with the proper
date format.
Any ideas out there?
Thanks!
dd-mmm-yyyy format. When I use the Format function in a Make Table query,
the subsequent wizard option to 'Save Format' is checked and grayed out.
The resulting txt file shows the correct format for the date but contains
other formatting I cannot use (field names, fixed length fields, a row of
dashes between data rows.) I need just a pipe-delimited file with the proper
date format.
Any ideas out there?
Thanks!