Importing Text files with .txx, .txs extensions

[Joe G.]

When trying to import comma-delimted text files using VBA,
Access2003, and WindowsXP. The text files have names
like: SID25512.txx and SID25512.txs. When Access tries
to import the file I get a "Run-time error '31519' You
cannot import this file." If I alter the suffix to .txt
the file imports correctly. I have another WindowsXP
machine (Access2003) where the files import correctly
regardless of the suffix.
Am I missing a setting somewhere?

 

[John Nurick]

Hi Joe,

This http://support.microsoft.com/?id=304206 shows how to change the
extensions that Access will accept. The neatest method is the last,
editing the registry (provided you're careful<g>).

Alternatively, this http://support.microsoft.com/?id=306144 includes
code that automatically makes a copy of the textfile with a .txt
extension and imports that.

 

[Joe G.]

The local help desk modified the registry entry
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0
\Engines\Text]to allow Access(R) to read the text files
with additional suffixes.