Need to export a date to a CSV file without exporting time elemen.



Need to export a date to a csv file without "" delimiters. These are required
for txt fields. Date needs to be ...,2004/11/05,"txt.....", 1.45. (ie no
delimiters). When exporting from Access table (set up as short date), exports
date correctly but also has time field ie (...,2004/11/05
00:00:00,"txt.....", 1.45.

How do I stop time element exported but not as txt ?

John Nurick

Hi Kevin,

I do this by including the " " delimiters in the query (for the fields
where they're needed), then exporting it with just the comma separator.
So the query might look something like:

SELECT SomeField, Format([DateField],"yyyy/mm/dd") AS fDateField, '"' &
TextField & '"' AS fTextField ...

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