Exporting to Fixed Length Text file

[Guest]

I am trying to export an Access table to a fixed length file. I am able to
export, but every time I do this, all number fields have a decimal and two
zeros appended. I have tried changing the fields to number and 0 decimals,
and text, but I always get the same result on the export. What am I doing
wrong?

 

[Ken Snell [MVP]]

Use a query that selects all the records from the table. In the query, use
calculated fields with specific formatting, e.g.,
MyNewField: Format([FieldName], "0")

Export the query.

 

[dbahooker]

if you're using Access Data Projects-- which you should be at this
point in the game-- you can do this type of thing via DTS quite easily.