Exporting table into CSV format

  • Thread starter Thread starter Michael Lam
  • Start date Start date
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
 
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]
 
You must log in or register to reply here.

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

How to Export Gmail Emails to PST Format? 4
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
How to import several csv files into 1 access table? 4
Which is the best MBOX Converter Tool different formats conversion? 4
date format problems with export to csv 1
Date format when exporting 2
Export part of table to .csv 1
Produce csv file with minimal interraction 2

Back
Top