• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 845
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

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