Designate a file extension in transfer text

[bravo6]

I need to send a fixed width file daily to a bank. The file needs to have the filename 123456.afs

When exporting to a fixed width file in Access (I am using macros) it only allows my to name the output file with a .txt extension. How can I get it to allow me to name the exported file with the .afs extension?

Thanks for your help!

 

[PHV]

Use VBA and its Name ... As ... instruction.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[bravo6]

I don't know VBA, can you give specific instructions?

 

[bravo6]

I wanted to pass along this fix that I found that allows one to name exported text files with any extension that they chose.

Installing Microsoft Data Access Components MDAC 2.1.2.4202.3 (GA) and the Microsoft Jet 4.0 SP3 update adds the following registry key when a program loads the Text IISAM.

HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Text\DisabledExtensions

The Value data for the registry key is:

!txt,csv,tab,asc,htm,html

The "!" allows only those file extensions to be changed. If you add other extensions to the value list you can then name the file with thise extensions.

You'll also need to add the desired file extensions to this registry value as well.

HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Text\Extensions