Values cutoff when export in .CSV format

[Bullsandbears123]

When I use the

DoCmd.TransferSpreadsheet acExport, , "myquery", strpath, True, ""

The numbers get cutoff.
The table will show....
[Field1]
12.1299
12.1546
10.1558

but the exported file in .CSV format only exports...

12.12
12.15
10.15

What could cause such a weird thing and HOW can I fix it to contain all the digits. When I export as an excel file it works fine, but the problem is I need the fie in .CSV

THANK YOU!

 

[Bullsandbears123]

Any ideas?

 

[PHV]

In myquery, try to use Format(Field1, "0.0000")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Bullsandbears123]

Worked like a charm. Thanks