TransferText Truncates Numbers

[Marty]

I have a problem I hope someone can help with. I am
trying to do a docmd.TransferText on a table he has a
number field that goes out to the fifth decimal place.
TransferText is truncating the the number to 2 decimal
places. AHHHH! I've tried and searched everything I know
of. If I make the field a text field and put the text
qualifer to anything other than "none" I get the entire
number however now I have a file with a bunch of text
qualifer characters in it - not acceptable! Does anyone
know a way around this problem?

TYIA
Marty

 

[Cashman]

Marty,
Had this problem with a budget program I was putting
together, which was accurate to 9 decimal places. When
exporting the file, I would only get 2 decimal places. I
found that it seems to be a OS issue not access. If you
goto control panel: Regional & Language options: Regional
Options: Customize: No of digits after decimal. Then
change this upto 9 decimal places, this should then work
for you export.

Cashman

 

[Ken Snell]

Create and save an Export Specification and use that in your TransferText
command. You can specify the decimal size in that specification.

Create the Spec by starting the export process manually, then click Advanced
button on bottom left of Wizard window.