exporting to text

G

Guest

When exporting a query or a table to text and using file extension of csv
dates get converted wtih format of date/time. Example: 12/19/2005 0:00:00.
Currently I have to find and replace to correct the csv file. Is there a way
to automate the export to the correct format?
 
K

Ken Snell \(MVP\)

The behavior that you see is by design.... that is how the ACCESS text file
export feature works for date/teim values.

To get the format that you desire, you must use a Format function in a
calculated field in a query in order to fix the date/time format that you
want, and then export the query.
 

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

Exporting time with date 2
Schema.INI 3
Date Format Incorrect on Export 1
Exporting to text file 1
Exporting results of a Union query 2
Need to export a date to a CSV file without exporting time elemen. 1
Problem formatting dates from CSV file 2
Exporting table containing dates 6

Top