Export date time to txt

  • Thread starter Roger Greenwood
  • Start date
R

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.
 
J

Joe Fallon

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