Change the file type
Go to the Extras folder in the Dimensions program folder. The default path is: C:\Program Files (x86)\Access Applications\Dimensions\Accounts\[Version]\Extras.
Locate the file called BacsFormats.ini and make a backup copy of it.
Save the backup to a safe location, such as the desktop.
Double-click the file to open it in Notepad. It appears in one of two formats depending on your Dimensions version:
Around 16 lines (earlier than v2.51a).
Around 40+ lines (v2.51a or later).
Earlier than v2.51a
If the file matches the earlier format, follow these steps before editing it.
Identify the number of the BACS format in use. Dimensions stores this in the BacsFormats.XML file in the same folder.
Open the BacsFormats.XML file.
Search for the format using Ctrl+F. For example, I am looking for ‘RBS Bankline v3’.
Find the entry in the XML file and to the left of the name is the number of the format, for Example ‘18’. With this information, create an entry in the BACSFormats.ini file.
The minimum entry required is:
[18]
ExportCSVasTXT=Y
Save the file.
v2.51a or later
For the later version, locate the line for the required format and change the N to Y.
Search for the format name — for example, 'RBS Bankline' — using the comments or Ctrl+F.
Change the N to Y as indicated in the comments, then save the file.
The next time the BACS Export is run, the file will be created with a .TXT extension.