Exporting text files

[MSHUM]

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.

 

[Jeanette Cunningham]

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

 

[MSHUM]

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.

 

[Jeanette Cunningham]

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

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.

 

[MSHUM]

I do these type of exports very frequently, and will use
Expr1:CStr([TheNumberField]) from now on. Thanks you for your help.

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

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.

 

[Jeanette Cunningham]

You're very welcome.

Jeanette Cunningham

I do these type of exports very frequently, and will use
Expr1:CStr([TheNumberField]) from now on. Thanks you for your help.

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

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.