export - no leading zeros

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Henry - 15 Jul 2005 16:45 GMT

Hi, I am exporting data from a table to a fixed-width text file using an
export spec.

One field I export is a text datatype, but it does only contain numbers. I
used a text datatype because I need to preserve the leading zeros. The end
result is the text file has stripped away the leading zeros...........why??

The export wizard shows them along the way........

I am using Access 2002

Thanks
Henry

Reply to this Message

Jeff Boyce - 15 Jul 2005 16:51 GMT

Henry

Consider creating a query that collects the information you'll be exporting.
On the text field with numbers, convert the field explicitly to
characters/text using the CStr() function (e.g., one of the query output
fields would look something like: ThisOutput: CStr([YourField])). Then
export the query.

Also consider checking the field-type the export specification is using for
this field -- it sounds like this is being exported as a numeric value.

Good luck

Jeff Boyce
<Access MVP>

> Hi, I am exporting data from a table to a fixed-width text file using an
> export spec.
[quoted text clipped - 10 lines]
> Thanks
> Henry

Reply to this Message