Exporting from Table/query to TXT file

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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, it worked! Thank you very much! (in fact a very simple solution)

Steve Schapel said:
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

Peter said:
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.
Click to expand...
Click to expand...
 
Back
Top