exporting decimal places to a comma-delimited file

[mikeschonlau]

I am exporting some tables of numbers with 7 decimal places to comma-delimited files. When I export the table, I end up with only 2 decimal places. The advanced option of the Export Wizard doesn't appear to let me specify the number of decimal places. I also tried adjusting the DecimalPlaces field in the table, but the same thing happened. Does anyone know how to keep thise decimal places?

 

[TexasTJ]

First, did you check Microsoft's Knowledgebase to see if they address this issue? I tried numerous variations of exporting from a table and query and kept getting only two decimal places.

One work-around I found was to build a query and for each column of numbers you want to retain the 7-digits beyond the decimal place use the formula of:

ColTitle: str([dblNumber])

replacing dblNumber with the various field names and ColTitle with a title for the column.

The export then treats the number as text, enclosing it in quotes, but retaining the 7-digits. When I then imported my sample export into Excel it did recognize the field as a number even though it was enclosed in quotes.