Exporting from Table/query to TXT file

[Guest]

Dear Access wizards,

I have imported an Excel file into a table. Inside this table there are
amounts included.
This table must be exported as a TXT file. This file will be imported into
our Back-Office system.
I do this with the command TransferTXT file and I create also a
specification name.
But if I have for example an amount of 80.20, the amount in the export TXT
file shows 80.2 . Our system does nog recognizes this amount. Do you have
a soluton?
I am using Access 2000/Windows 2000.

 

[Steve Schapel]

Peter,

Instead of exporting directly from the table, do your export from a
query, where you use a calculated field like this...
TextAmount: Format([YourAmountField],"0.00")

 

[Guest]

Steve, it worked! Thank you very much! (in fact a very simple solution)

Peter,

Instead of exporting directly from the table, do your export from a
query, where you use a calculated field like this...
TextAmount: Format([YourAmountField],"0.00")

--
Steve Schapel, Microsoft Access MVP

Dear Access wizards,

I have imported an Excel file into a table. Inside this table there are
amounts included.
This table must be exported as a TXT file. This file will be imported into
our Back-Office system.
I do this with the command TransferTXT file and I create also a
specification name.
But if I have for example an amount of 80.20, the amount in the export TXT
file shows 80.2 . Our system does nog recognizes this amount. Do you have
a soluton?
I am using Access 2000/Windows 2000.