Exporting to a text file - truncating trailing values

J

Julee

I am having a problem exporting from a table to an ascii
file. In the table I can have a field size= double,
decimal places = auto. The values in this table field
don't have consistent size thus the auto setting for
decimal places. When I export the table data to a flat
file a value that is 1 is 1.0, a value that is 0.951 is
0.95, .765 is .76 and so on. I am more concerned about
truncating values than anything else. Does anyone have
suggestions or have you run into this issue? Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access2000 Export to delimited text is truncating decimals 2
Exporting to text file 1
Exporting Delimited Text File Truncating 1
Export delimited text file 1
exporting to text file 1
Exporting to a flat file issue 7
Exporting query to XL is truncating field data 7
file type export problem 5

Top