|
Home > Archive > MS Access Database with External Data > September 2005 > Access 97 Export to text dropping decimal spaces
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Access 97 Export to text dropping decimal spaces
|
|
| melakeside 2005-05-12, 8:25 pm |
| We are exporting and access table, export delimited, and the statistics have
4 spaces after the decimal. The table reflects for example, 1.7542; after
export to text the data has changed to 1.75. I have tried an export spec., I
have tried changing the field properties to Text; I have tried Double, 4
spaces, on design; etc. Anyone have this issue and how did you fix it - any
suggestions other than send it to Excel (we are trying to avoid at this point
since another application is picking up this text file and using it).
Thank you
melakeside
| |
| Douglas J. Steele 2005-05-12, 8:25 pm |
| Try creating a query, and use the Format function on the field. Export the
query rather than the table.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"melakeside" < melakeside@discussio
ns.microsoft.com> wrote in message
news:B9D9C41C-9853-4F74-8378- A4C84FE07D04@microso
ft.com...
> We are exporting and access table, export delimited, and the statistics
> have
> 4 spaces after the decimal. The table reflects for example, 1.7542; after
> export to text the data has changed to 1.75. I have tried an export
> spec., I
> have tried changing the field properties to Text; I have tried Double, 4
> spaces, on design; etc. Anyone have this issue and how did you fix it -
> any
> suggestions other than send it to Excel (we are trying to avoid at this
> point
> since another application is picking up this text file and using it).
>
> Thank you
> melakeside
| |
| happybappa 2005-09-26, 3:24 am |
| see also "doubles are rounded when exporting to ASCII",
change the regional settings of your computer, option "No. of decimals after
decimal"
Bart
"Douglas J. Steele" wrote:
> Try creating a query, and use the Format function on the field. Export the
> query rather than the table.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
>
> "melakeside" < melakeside@discussio
ns.microsoft.com> wrote in message
> news:B9D9C41C-9853-4F74-8378- A4C84FE07D04@microso
ft.com...
>
>
>
|
|
|
|
|