Exporting CSV Losing Precision

[spg2112]

Hey all,

I'm exporting a table to a CSV format and I need my quantity field to retain the 5 or 6 decimal places. It's truncating it to 1 decimal. I tried changing the format from a number to text but I get 'some data may be lost errors'. Any ideas? Thanks!

Steve

 

[Joe4]

Are you exporting a table or query?
Does the table/query you are exporting show 6 decimal places?
How are you exporting it?
Are you using a saved Export Specification (if so, you may need to rebuild it)?
What program are you using to view your exported CSV?

 

[spg2112]

Are you exporting a table or query?
table

Does the table/query you are exporting show 6 decimal places?
Yep

How are you exporting it?
Via Access esxport to text wizard

Are you using a saved Export Specification (if so, you may need to rebuild it)?
No but I tried creating one for it and couldn't find where to edit the field format

What program are you using to view your exported CSV?
Excel

 

[Joe4]

From my Google search, it looks like it might be a bug.
The following link provides a workaround: http://social.msdn.microsoft.com/Forums/en-US/accessdev/thread/5bba131c-d6cd-4548-9f0f-c85947b3d81d

 

[Joe4]

So in a nutshell, leave it as a number in your table.
Then create a new query off of this table.
Add all your fields except this number field.
Let's say the number field is named "Amount". Enter this calculation into the query to convert it to text with 6 decimals:

NewAmt:format([Amount],"0.000000")

Now do the export from this query.

 

[spg2112]

OK I'll give that a try thank you!

 

[spg2112]

Works perfectly thanks!