Leading zeroes disappear exporting to Excel

[Stuart]

I have a zip/postal code field in my database. It is a
text field, invariably filled with 5 digit numeric
strings. It works exactly as it should. However, when I
export a list of addresses to excel, excel suppresses the
leading zero. I have tried different Access formats,
input masks, etc., but nothing seems to prevent this.
Any suggestions?

Thanks, Stuart

 

[Pieter Wijnen]

excel is to smart for it's own good...
you can either prefix with a apostrophy '
or (try - haven't done so myself)
to make an export spec specifying the field to be of type text
or use automation...

hth

pieter

 

[Mike Painter]

I have a zip/postal code field in my database. It is a
text field, invariably filled with 5 digit numeric
strings. It works exactly as it should. However, when I
export a list of addresses to excel, excel suppresses the
leading zero. I have tried different Access formats,
input masks, etc., but nothing seems to prevent this.
Any suggestions?

You could place a letter before the first few strings that start with zero.
or format the string after it got there or ignore the problem.

Why would you want Addresses in Excel anyway? Access can produce far better
reports.