Incorrect value- export to Excel

W

Weili

Hi,

I use DoCmd.TransferSpreadsheet to export data from Access
2002 to Excel. The number in Access was 2.7 but it became
2.699999999983 in Excel. Does anyone know why?

Also it happened the same problem when I built a external
data query in Excel to Access.

Thank you for help very much!

Weili
 

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

Incorrect value when exporting to Export 0
Exporting to Excel 0
Export Access pivot table to Excel 0
Strange problem exporting query to excel 2
TransferSpreadsheet does not transfer all of the data... 0
Exporting to Excel 2007 1
Export to Excel Not Available 1
Access Export of data to Excel using VBA - data looks awful 4

Top