export table to text file

[santosh1]

I am trying to export a table to a text file from Access. The numeric fields have data with 5 decimal places; however, when I export I am only getting a text file with 2 decimal places. I checked properties of tables, and the numeric fields were set to "Double", Decimal places as "Auto". I changed decimal places to b "5" and tried to reexport, but am still getting the numbers cut off. I cannot find anything in the export criteria to allow me to choose number of decimal places.

How can I export table to text file with more than 2 decimal place? Thankyou for your help.

 

[Rolliee]

Is this a one time deal? What happens if you open the table and press <control>A and then <control>C, then open WORD with a new document and press a <control>V

Try it and see.

rollie@bwsys.net