To export numbers with any more than 2 decimal places to a .txt file, you
must use Expr1:CStr([TheNumberField])
in a query. That is the only method that retains all the numbers to the
right of the decimal point when exporting as text.
If your data was already in a query, you could have just added
Expr1:CStr([TheNumberField])
to the query. That would have cut out a couple of steps for you.
Jeanette Cunningham
MSHUM said:
Thanks - that works well. I used a similar "work around" to get my data
exported. The data was already in a query - so I imported the query as
a
table and then changed the format of my double precision numbers to
text -
and then exported the data. Seems like there should be a better way to
export
double precision numbers to a text file and retain all of the digits -
but
both of these methods work. Thanks again for the reply.
:
This question comes up quite often.
Instead of exporting the table, create a query based on the table and
export
the query instead.
However before exporting the query, create a new calculated field in
the
query. The calculated field is a formatted version of the number
field.
In a new column in the query type the following:
Expr1:CStr([TheNumberField])
Replace TheNumberField with the name of your field.
Now export the query.
Jeanette Cunningham
When I export data from Access to a delimited text file, double
precision
numbers with 12 decimal places in the database are truncated to 2
decimal
places in the text file. I am using the export wizard in Access.
Does
anyone
know a way to export all of the digits of the double precision
numbers?
I
can
export to Excel okay, but the tables I need to export have too many
records
for Excel.
Thanks for any help that may be offered.