Incorrect value when exporting to Export

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- export to Excel 0
VBA - exporting serial letters to single documents 0
Exporting to Excel 0
Strange problem exporting query to excel 2
Export Access pivot table to Excel 0
Export Using ExportSpreadsheet 1
Exporting to Excel 2007 1
TransferSpreadsheet does not transfer all of the data... 0

Top