• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 837
  • Last Modified:

Access 2007 Unable to Import text file with no text extension

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?
0
bgcpc
Asked:
bgcpc
  • 2
1 Solution
 
peter57rCommented:
I don't have A2007 on this machine so I can't check anything but Access2007  no longer uses Jet- it uses the ACE updated version of JET.  This might well have its own registry settings, since JET does still exist for other purposes.
Perhaps search the registry for ACE?
0
 
bgcpcAuthor 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.
0
 
bgcpcAuthor Commented:
peter57r
I will give you credit for heading me in the right direction.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now