Exporting to Fixed Length Text file


G

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?
 
Ad

Advertisements

K

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

Advertisements

D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top