Export date time to txt

[Roger Greenwood]

I need to export date time from MS Access to a .txt file
with leading zeros on the hour segment of the time (24 hr
format)
eg 03/23/2004 7:43:02 needs to be exported as 03/23/2004
07:43:02.
Thanks,
Roger Greenwood.

 

[Joe Fallon]

Use a query and format that field using the Format function.
Export the query.