| | |
|
|
|
Date fields in an ASCII delimited file |
|---|
| message from David Howlett on 5 May 2004 |
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?
|
| Dirk Goldgar replied to David Howlett on 5 May 2004 |
"David Howlett" <dhowlett@laoh.ucla.edu> wrote in message
news:%23UqPmItMEHA.2876@TK2MSFTNGP09.phx.gbl
You can lose the time by exporting a query that applies the Format
function to your date field to convert it to a properly formatted
string; e.g., Format(DateField, "m/d/yyyy"). Then specify "{none}" for
the text qualifier in the export wizard.
|
|
Archived message: Date fields in an ASCII delimited file (Microsoft Access)
