I am exporting the content of a query to a CSV file.  I used to export it to
excel but it got to be over 65,000 records so I would like to use CSV.  The
problem lies with the dates.  Although the dates look fine in the query
[e.g. 12/11/2002] they seem to convert automatically to date/time format in
the CSV file [e.g. 12/11/2002 00:00:00].  I know that the customer for this
spreadsheet can change it on arrival but I want to be kind to him as he is
only an accountant.  Is there any way I can ensure that the CSV file simply
gives the date as before?

Steve Klein

in your query, don't select the data field, select a derived field based on
that date, something like cstr(MyDate) or format.  Check out the format
function to get the exact date format you want, and use that as the field in
your query...

-----Original Message-----
From: Steve Klein [mailto:Stephen@K...]
Sent: Monday, November 18, 2002 11:54 AM
To: Access
Subject: [access] Export to CSV



I am exporting the content of a query to a CSV file.  I used to export it to
excel but it got to be over 65,000 records so I would like to use CSV.  The
problem lies with the dates.  Although the dates look fine in the query
[e.g. 12/11/2002] they seem to convert automatically to date/time format in
the CSV file [e.g. 12/11/2002 00:00:00].  I know that the customer for this
spreadsheet can change it on arrival but I want to be kind to him as he is
only an accountant.  Is there any way I can ensure that the CSV file simply
gives the date as before?

Steve Klein