When import Excel, could not find object

[ccento]

I have Access 2003 and when I run the import wizard, I get and error message
that the Jet Database engine can't find the object - and even if I select a
different file with a shorter file name, it's still trying to find the old
object or file. I have rebooted, run Compact and Repair and it's almost
"stuck" on that old file.

Help.

It all started because I have a corrupted replica so I exported the data in
the hopes that I can re-import into the master and when I import, that's when
I get the above error. The replica won't let me synch b/c it says "the field
is too small to accept the amount of data you attempted to add". If you have
any help with that problem, that would be great, too.

Thanks

 

[Jeanette Cunningham]

Hi,
these steps usually solve this and similar problems.

If the import/export wizards don't work at all, or if you get "No object
in this control" re-register ACCWIZ.DLL.


If it's one or more file formats that aren't listed, re-register the
following files
msexcl40.dll (Excel)
msxbse40.dll (dBase)
mspdox40.dll (Paradox)
mstext40.dll (Text, CSV, tab-delimited))

In Access 2007 - I'm not sure what the file names are called.
In Access 97, the filenames contain 35 instead of 40.

To re-register a DLL file,

1) Locate it (usually all these are in the Windows\System32 or
WINNT\System32 folder.

2) Locate the file regsvr32.exe.

3) Drag the DLL file's icon onto the regsvr32.exe icon.


Jeanette Cunningham