3433 Invalid setting in Excel key of the Engines section of the Windows Registry

24 Feb 2005 3:50 PM

Tim

Hi,
I am getting this error (3433 Invalid setting in Excel
key of the Engines section of the Windows Registry)
when I import a text file to my Access database.

Here's what i'm using:
VB6 application
Windows XP SP2
Office XP professional
msjet40.dll version (4.0.8618.0) The last version
available.

any clues?

thanks, tim

2 May 2005 10:07 PM

Bruce H

Without sample code this is a guess. If you are not using a standard file
extension try adding your file extension to the
HKLM\"SOFTWARE\Microsoft\Jet\4.0\Engines\Text\DisabledExtensions" key. Add a
comma and your extension without any space. Don't let the key name fool you.
There is a "!" at the beginning of the value string that negates the
remaining string. In effect it means "allow these extensions".

Hope this helps.
Bruce H

Show quoteHide quote

"Tim" <t**@resoftware.net> wrote in message
news:1eca01c51a88$a20e7ca0$a501280a@phx.gbl...
> Hi,
> I am getting this error (3433 Invalid setting in Excel
> key of the Engines section of the Windows Registry)
> when I import a text file to my Access database.
>
> Here's what i'm using:
> VB6 application
> Windows XP SP2
> Office XP professional
> msjet40.dll version (4.0.8618.0) The last version
> available.
>
> any clues?
>
> thanks, tim
>

27 May 2005 9:39 PM

Tim

thanks for responding although I still get the same error. here are the
values in my Disabled extensions key "!txt,csv,tab,asc,tmp,htm,html"

i also unloaded Microsoft Office XP and loaded Office 2000, but still get
the same error.

any other suggestions?

Show quoteHide quote

"Bruce H" wrote:

> Without sample code this is a guess. If you are not using a standard file
> extension try adding your file extension to the
> HKLM\"SOFTWARE\Microsoft\Jet\4.0\Engines\Text\DisabledExtensions" key. Add a
> comma and your extension without any space. Don't let the key name fool you.
> There is a "!" at the beginning of the value string that negates the
> remaining string. In effect it means "allow these extensions".
>
> Hope this helps.
> Bruce H
>
> "Tim" <t**@resoftware.net> wrote in message
> news:1eca01c51a88$a20e7ca0$a501280a@phx.gbl...
> > Hi,
> > I am getting this error (3433 Invalid setting in Excel
> > key of the Engines section of the Windows Registry)
> > when I import a text file to my Access database.
> >
> > Here's what i'm using:
> > VB6 application
> > Windows XP SP2
> > Office XP professional
> > msjet40.dll version (4.0.8618.0) The last version
> > available.
> >
> > any clues?
> >
> > thanks, tim
> >
>
>
>