Export Text File with Trailing Zeros

[Bonediggler1]

Hi-

I am trying to export the contents of a table to a text file. One of the fields contains dollar amounts. If I specify in the table the format to be Double/Fixed/Two decimal points, all values show correctly in the table...i.e. 1 becomes "1.00" and so forth. However, when exporting this table, the trailing zeros are dropped. If I query the table, change this field to text in the query and then export via VBA, the trailing zeros are dropped. If I manually export this query, the trailing zeros are maintained...

Not sure what I'm missing here. I am obviously trying to keep the trailing zeros when exporting.

Please advise...

Thank you!!

 

[SkipVought]

Hi,

So what's different in the VALUES of

.1
or
.1000

???

Leading and trailing zeros are merely FORMATTING. However, you may have a point if the file is being used as input data for a program that NEEDS the leading or trailing zeros or it will ABEND.

What's the bottom-line requirement?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[LisaWay]

In your query, do you have a column defined like:

DollarsTxt: Format([Dollars],"Fixed")

I found that whether you export manually or via DoCmd.TransferText, whether the export is delimited or undelimited, it always includes two digits to the right of the decimal point so long as you use the above field definition. I am using Access 2007.

Regards,
Lisa

 

[Bonediggler1]

SkipVought: Yes, the file will be uploaded into an A/R system that requires all dollar amounts to have 2 digits to the right of the decimal.

LisaWay: I am using Access 2003 but will try your suggestion and see what happens...

 

[Bonediggler1]

LisaWay-

That seems to work. Thanks a lot!!