Access - export to fixed file format - Date issues

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am export data from Access to a fixed file using text format. I hit the
advance tab and set my specifications for the flat file.
My data includes date formats that are custom (YYYYMMDDHHNN). When I export
to a fixed length text file, it is changing the date format to the fomat
under export specifications?
Does anyone know how to override the date options that are provided under
the advance tab?

Thanks any help is greatly appreciated.
 
Indydawg said:
I am export data from Access to a fixed file using text format. I hit the
advance tab and set my specifications for the flat file.
My data includes date formats that are custom (YYYYMMDDHHNN). When I export
to a fixed length text file, it is changing the date format to the fomat
under export specifications?
Does anyone know how to override the date options that are provided under
the advance tab?

Thanks any help is greatly appreciated.
Click to expand...
Try using a query and a calculated field to format your date as a text
field.

MyDate: Format("yyyymmddhhnn", FieldInTable)

Change your export specification to a text field.

Ron
 
Ronald W. Roberts said:
Try using a query and a calculated field to format your date as a text
field.

MyDate: Format("yyyymmddhhnn", FieldInTable)
Click to expand...

Other way around: MyDate: Format([FieldInTable], "yyyymmddhhnn")
 
Back
Top