TransferText from a *.dat file

[Guest]

I have inherited a macro that uses the transfertext method to import fields
from a file with a .dat extension. It is using a specification name to
format the imported fields, but I have no way of editing the specification.
Apparently there is an issue, because the files are no longer importing
correctly.

 

[Ken Snell [MVP]]

ACCESS no longer allows importing text files with a .dat extension (security
reasons). Easiest fix is to manually change the extension to .txt (or add
..txt to the end of the filename), and then have your macro import the file
with the .txt extension. This also can be done programmatically, but not
directly in a macro... you need to use VBA code.

Otherwise, you'll need to change the registry settings to allow this
import... not a recommended approach, but it can be done. See
http://support.microsoft.com/default.aspx?scid=kb;en-us;304206.