export table without time format
export table without time format
(OP)
I am trying to create an export to a .txt file of a table with a field that is the date datatype. How do I get it to export without the added time format. Where I need to import this information, has a problem with that additional format.
I am using Access 2007
Micki
I am using Access 2007
Micki
RE: export table without time format
hi,
You must CONVERT your Date/Time NUMERIC data to STRING, using the Format() function...
CODE
Skip,
Just traded in my old subtlety...
for a NUANCE!