Access truncates decimals when exporting to text file

[Grant Palin]

I'm trying to export a single table to a text file. After I get through the export wizard, I check the text file, and find that the decimals are truncated to two decimal places! Is there a way to prevent that...some option in Access' export wizard?

[Grant Palin]

I found out something else. When first starting the export wizard, there was an option to "Save Formatted", or something like that. I selected that option, and ran the wizard. At the end, I opened the resulting file, and lo and behold! the decimals were not truncated! But there were boxes surrounding each field, made up of dashes (-) and vertical lines (|). I COULD set up a regular expression to eliminate those, and preserve the decimals, but hopefully there's a simpler way than that...