Export zero-filled fields into a text file

  • Thread starter Thread starter Angie
  • Start date Start date
A

Angie

I am trying to export a fixed length file with some zero-
filled fields. It is dropping the leading zeroes. How
can I export & keep the leading zeroes?

Thanks.
 
Hi Angie,

Create a query that uses calculated fields like this to generate the
zero-padded fields. This

fXXX: Format([XXX], "000000")

pads the contents of field XXX to 6 characters wide.
 
Hi,
Thanks for the suggestion, but it didn't work. The
fields are zero padded in the table, but when I do the
export it is dropping the zeroes in my text file. I am
using an export specification.

Thanks,
Angie
-----Original Message-----
Hi Angie,

Create a query that uses calculated fields like this to generate the
zero-padded fields. This

fXXX: Format([XXX], "000000")

pads the contents of field XXX to 6 characters wide.

I am trying to export a fixed length file with some zero-
filled fields. It is dropping the leading zeroes. How
can I export & keep the leading zeroes?

Thanks.
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
 
You have to create a query that uses the Format() function in calculated
fields like the example I gave. Then export the query. Using the Format
property of the fields in the table won't do the job.


Hi,
Thanks for the suggestion, but it didn't work. The
fields are zero padded in the table, but when I do the
export it is dropping the zeroes in my text file. I am
using an export specification.

Thanks,
Angie
-----Original Message-----
Hi Angie,

Create a query that uses calculated fields like this to generate the
zero-padded fields. This

fXXX: Format([XXX], "000000")

pads the contents of field XXX to 6 characters wide.

I am trying to export a fixed length file with some zero-
filled fields. It is dropping the leading zeroes. How
can I export & keep the leading zeroes?

Thanks.
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
Click to expand...
 
Back
Top