C
Charles Zingeline
I have a table, built by a query, with a mix of text and numbers. The text
and integers export to a comma-delimited .csv file just fine.
However, one field from my base table is defined as double, fixed, 4 places.
I can't figure out out to successfully export this field. The file resulting
from the export always rounds the number to 2 decimal places - useless for
my application.
The Advanced tab on the export wizard gives me no place to tell Access 2000
that I want all 4 decimal digits.
How can I do this? How can I create a specification that will not do
rounding? That will maintain my 4 places?
Your suggestions, please. This seems like a simple thing, but...
I just discovered TransferText and this may be a way.
Thanks.
Charlie
and integers export to a comma-delimited .csv file just fine.
However, one field from my base table is defined as double, fixed, 4 places.
I can't figure out out to successfully export this field. The file resulting
from the export always rounds the number to 2 decimal places - useless for
my application.
The Advanced tab on the export wizard gives me no place to tell Access 2000
that I want all 4 decimal digits.
How can I do this? How can I create a specification that will not do
rounding? That will maintain my 4 places?
Your suggestions, please. This seems like a simple thing, but...
I just discovered TransferText and this may be a way.
Thanks.
Charlie
The number of decimal places that MS Access exports a floating point field to a text file with is determined by the number format of the Regional Settings of your local PC: go to Start -> Settings -> Regional and Language Options, and the format shown in "Number" is the format Access will use...