Exporting table into CSV format

M

Michael Lam

Dear all,

I would like to export the a table into CSV. But I found that the
numeric data only shows 2 d.p in CSV while the original data is actually a
Double. Can anyone help me on this pls?

Thanks

With regards,
Michael Lam
 
J

John Vinson

Dear all,

I would like to export the a table into CSV. But I found that the
numeric data only shows 2 d.p in CSV while the original data is actually a
Double. Can anyone help me on this pls?
Click to expand...

Use the Format() function to export the value to (say) twelve places,
or some format which preserves the precision you need.

John W. Vinson[MVP]
 
Top