We help IT Professionals succeed at work.

Access 2007 Unable to Import text file with no text extension

bgcpc
bgcpc asked
on
873 Views
Last Modified: 2008-01-09
We have an Access 2000 database that the users import .pos files as text files. We added the extension to the following registry key:
HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Text\DisabledExtensions
This worked for Access 2000/2003.
We are now testing this database on Vista Business with Office 2007. With this same registry change, Access 2007 does not recognize the .pos file as a text file for import. Does anyone know where to change this for Access 2007?
Comment
Watch Question

CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Thanks for the response, but did not find anything under ACE. This got me searching a little deeper and stumbled across the solution. The key to change is:
HKEY_LOCAL_MACHINE\Software\Microsoft\Office\12.0\Access Connectivity Engine\ISAM Formats\Text\ImportFilter
I added the extension here and it fixed the problem.

Author

Commented:
peter57r
I will give you credit for heading me in the right direction.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.