Exporting into .txt and loosing data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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

Shane said:
Very perplexing things go on with an export I'm trying to do. When I try
Click to expand...
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
Click to expand...
will import and I need to find a way to drop the autonumber field without
loosing the cents in the dollar field..
 
Back
Top