link to text files with non-standard extentions 2

[pjtarheel]

I'm trying to link to some text files on a CD that do not have standard extentions that Access recognizes as text. Is there a way I can make that work (other than copying and renaming each file, which is a pain)?

Thanks!!

Paul

 

[Remou]

You can either programmatically copy and rename, or you can mess with the registry:

http://support.microsoft.com/default.aspx?scid=kb;en-us;304206

ACC2000: Importing or Linking a Text File Fails for a File That Does Not Have a Valid File Name Extension

 

[Ed2020]

There is a registry hack you can apply to do this.

Copy and paste the following into a text file and then save is as Fix.reg. Then launch the Fix.reg file.

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\ISAM Formats\Text]
"ExportFilter"="Text Files (*.*)"
"ImportFilter"="Text Files (*.*)"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Text]
"DisabledExtensions"=""

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\ISAM Formats\Text]
"ExportFilter"="Text Files (*.*)"
"ImportFilter"="Text Files (*.*)"

The following will reverse the changes, if you decide to:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\ISAM Formats\Text]
"ExportFilter"="Text Files (*.txt;*.csv;*.tab;*.asc)"
"ImportFilter"="Text Files (*.txt;*.csv;*.tab;*.asc)"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Text]
"DisabledExtensions"="!txt,csv,tab,asc,tmp,htm,html"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\ISAM Formats\Text]
"ExportFilter"="Text Files (*.txt;*.csv;*.tab;*.asc)"
"ImportFilter"="Text Files (*.txt;*.csv;*.tab;*.asc)"

Ed Metcalfe.

Please do not feed the trolls.....

 

[pjtarheel]

Thanks, guys! I'm always amazed how quickly I can get answers here!