Precision lost when exporting

[stnkyminky]

Access shows the value of a column as .02658. When I export the table into a csv file, the value is truncated to .02.

Is there anyway to fix this problem?


Thanks

Scott
Programmer Analyst
<{{><

 

[DougP]

Using VBA code
instead of the wizard
' open your table here
Open &quot;YourFile.CSV&quot; for output as #1
for a = 1 to rs1.recordcount
'out put the fields here
Mydata = rs1.Field1 & &quot;, &quot; & rs1.Field2 & &quot;, &quot; & rs1.Field3
Print #1, Mydata
rs1.movenext

Close #1

DougP, MCP, A+