Export delimited text file

[Guest]

When exporting a text file from Access as a delimited text file, it will
change the decimal values in the table to a different value then displayed in
the document. How do I keep the value the same without it being changed
during the exporting process? And why does it do this?

 

[Ken Snell \(MVP\)]

You must use a calculated field in your exported query that will "set" the
number of decimal places that you want -- this calculated field replaces the
original field. Let's say your original query was this:

SELECT Field1, Field2
FROM Tablename;

And let's say Field1 is the one you want to have 5 decimal places:

SELECT Format(Field1, "0.00000") AS NewField1, Field2
FROM Tablename;

ACCESS defaults to two decimal places for numbers when exporting to text
files. It also defaults to give you date and time values for date/time
fields even if you are only storing date values in the fields, etc.