Access 2007 Unable to Import text file with no text extension

Posted on 2007-10-09
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:
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?
Question by:bgcpc
    LVL 77

    Accepted Solution

    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?
    LVL 1

    Author Comment

    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.
    LVL 1

    Author Comment

    I will give you credit for heading me in the right direction.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now