With export decimals are disappearing

[Marloes]

I have a list with coordinates in acces with 5 numbers after the
decimal sign, when I export that table to a text file it only
reproduces 2 numbers after the decimal sign. How can i prevent this
loss of information?

sorry for my poor English and thanks in advance!

 

[Arvin Meyer [MVP]]

I use I/O syntax. It may be somewhat archaic, but it allows you to format
exactly the way you want. I use recordsets, but you can also use form
variables:

Open "C:\SomeFile.txt" For Append As #1
Print #1, Format(rst!CostCode, "0.00000") & "," &
rst!Cost
Close #1

 

[Douglas J. Steele]

You should be able to do the same thing in a query, and then export the
query, rather than the table.

SELECT Field1, Format(Field2, "0.00000") FROM MyTable

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)