Exporting a table problem

C

CD Tom

I have a table that has columns setup with 3 decimals, however when I export
the file to a .txt it is only exporting out two decimals and I'm losing the
3rd decimal which is really causing a problem. Does anybody know what is
causing this and how I can fix it.
Thanks for any help.

CD
 
S

Seth Schwarm

CD Tom:

I suspect the values stored in the table are only to two decimal accuracy -
meaning the third decimal place is actually a zero (Ex. - .120).

You can fix this by building a query on the table instead of using the table
itself.

Seth Schwarm
 
C

CD Tom

When I do the export manually, I can see the data and it shows 3 decimals ex
23.123 but when I look at the .txt file that it exports it only shows 23.12
The table def. is set to three decimal points. It really doesn't make any
sense to me. This is very important to have all 3 decimals show up in the
..txt file because I use them to restore to other databases and I'm losing
that 3rd decimal. Hopefully it's something simple that I'm just missing.
 
Top