Date fields in an ASCII delimited file

D

David Howlett

I am exporting a table to an ASCII delimited file. All my date/time fields
export with a time stamp (i.e. 5/4/2004 03:04). I want the ASCII file to
contain only the date without quotes (5/4/2004).

How can I do that?
 
D

David Howlett

If I write a query and use (for example) the format() function. Won't it
convert the vaule to a string and therefore put quotes around it? The import
process on the other end requires a date field m/d/yyyy with no quotation
marks. Thanks.



Write a query.
Format the data in the query.
Export the query.
--
Joe Fallon
Access MVP



David Howlett said:
I am exporting a table to an ASCII delimited file. All my date/time fields
export with a time stamp (i.e. 5/4/2004 03:04). I want the ASCII file to
contain only the date without quotes (5/4/2004).

How can I do that?
Click to expand...


..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fixed Width - No delimiters - ASCII Text File 7
create ascii file to unique design 2
Exporting to ascii file 4
Date fields in an ASCII delimeted file 1
VBA - exporting serial letters to single documents 0
Export to ASCII file 1
Export Date without Time to text tab delimited file 3
Odd character display (ASCII 128-159) 1

Top