G
Guest
How do I add ".ext" file extension to Microsoft Access (v97/2000) so Access
sees it as a text file (.txt)?
sees it as a text file (.txt)?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John Nurick
Hi Kevin,
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.
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.
G
Guest
In Windows XP SP2, I very carefully altered the registry as suggested in
Method 3 of Article ID 304206. There were no change in my results. I cannot
import a normal txt file that I previously exported from Access in the first
place with the .txt extension changes to .ext. In addition, I tried adding
ext to the Extensions key and to the Jet 3.5 equivalent keys. Nothing is
helping so far.
Any further ideas?
Method 3 of Article ID 304206. There were no change in my results. I cannot
import a normal txt file that I previously exported from Access in the first
place with the .txt extension changes to .ext. In addition, I tried adding
ext to the Extensions key and to the Jet 3.5 equivalent keys. Nothing is
helping so far.
Any further ideas?
G
Guest
Next I tried replacing (*.txt;*.csv;*.tab;*.asc) with
(*.txt;*.csv;*.tab;*.asc;*.ext) everywhere I found it in the registry. I was
able to import it, but it went through it's usual import routine. And it
would not export with a .ext extension. But at least I made some progress.
Any further suggestions?
Kevin (otherwise known as the Registry Mad Dog)
(*.txt;*.csv;*.tab;*.asc;*.ext) everywhere I found it in the registry. I was
able to import it, but it went through it's usual import routine. And it
would not export with a .ext extension. But at least I made some progress.
Any further suggestions?
Kevin (otherwise known as the Registry Mad Dog)
J
John Nurick
As far as I know all you need to do for Access 2000 is to modify the
DisabledExtensions registry key as described in the article.
If you're using Access 97, I think you have to create a corresponding
key for Jet 3.5
HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\3.5\Engines\Text\DisabledExtensions
to exclude the extensions you want to be able to use (i.e. the same list
as in the Jet 4.0 version including the initial !).
DisabledExtensions registry key as described in the article.
If you're using Access 97, I think you have to create a corresponding
key for Jet 3.5
HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\3.5\Engines\Text\DisabledExtensions
to exclude the extensions you want to be able to use (i.e. the same list
as in the Jet 4.0 version including the initial !).