Acc07 can't import this file

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

My Access 2007 is unable to import a text file with an extension ".08". For
example, we have filename like xxxx.08

I am Using OS XP Pro Sp3 with the changes to my DisabledExtension in the
registry at
HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Text\DisabledExtensions

I change it to "exe" to allow binary and I have no problem in reading these
files using Access 2003 with the same OS. With the same OS on a Virtual PC,
with Office 2007 installed and using Access 2007 Sp1, I am unable to import
these files. I confirm this by changing the .08 to .txt and it works. This
was explain in aritcle KB245407

I would appreciate any help you can offer. Currently, I know that can
change all of the file extensions, but I would like not to. It seems the
registry changes doesn't work for Access 2007.

Thank You,

Gary
 
The problem is access 2007 does not use "jet" anymore, but has a new version
called ACE

You find the "key" you looking for here:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office
\12.0\Access Connectivity Engine\Engines\Text


Since you need to do this all on computers, I would consider either writing
some code that

1) pops open the file dialog browse
2) renames the file
3) import data
4) rename file back

In fact, better for step 3 would be to have your code "copy" the file. You
could automaton all of these steps with a one button click process.

Anyway, the above is the key you need....
 
Back
Top