Exporting into .txt and loosing data

[Shane]

Very perplexing things go on with an export I'm trying to do. When I try to export data from a table w/o a primary key into a .txt file, my field filled with dollar amounts ( exp. $15.26) looses it's cents (exp. 15.26 turns into 15). If I insert a autonumber field as a primary key. . . my cents show up again in the .txt field..

The program that is importing my data is very particular about the way it will import and I need to find a way to drop the autonumber field without loosing the cents in the dollar field.

Anyone ever seen this happen before and, hopefully, know a fix??
Thanks
Shane

 

[Roger Carlson]

Is this a fixed width format or comma delimited? If fixed-width, look at
the export specification to make sure the fields are corresponding to the
correct spec field.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

Very perplexing things go on with an export I'm trying to do. When I try

to export data from a table w/o a primary key into a .txt file, my field
filled with dollar amounts ( exp. $15.26) looses it's cents (exp. 15.26
turns into 15). If I insert a autonumber field as a primary key. . . my
cents show up again in the .txt field...

The program that is importing my data is very particular about the way it

will import and I need to find a way to drop the autonumber field without
loosing the cents in the dollar field..