Export zero-filled fields into a text file

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

 

[John Nurick]

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.

 

[Angie]

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.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.

 

[John Nurick]

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.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.