Import Error Excel to Access 2003

  • Thread starter Thread starter JP
  • Start date Start date
J

JP

When I try to import Excel and/or Notepad files. Access states it has
encountered an error and shuts down, the send error report option comes up,
and the import wizard never shows up. Any ideas on what is causing this, and
how to correct it?

Would really appreciate help on this one.

PS - Have already reinstalled Access 2003, did not help.
 
JP,
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
 
Hello Jeanette,

Thanks for the idea. I tried to re register the libraries you mentioned. I
started with ACCWIZ, and also did it for the excel, dbase, txt dll files as
well. I am having the same issue. Does not tell me what the error is, but
when I try to import it hangs and then errors out and pulls up the send error
report message. Does anyone have any other ideas???

Thanks!
 
Hi JP,

Some brainstorming ideas - create a new blank database, try to import an
Excel sheet or text file. Find out if it's your particular work database or
your Access installation in general that can't do it.

If the blank database works, then compact & repair the work database. If
that doesn't solve the problem, make a new version of the work database, by
importing the data and objects - cut and paste code as necessary. Might want
to do this in stages, testing your import ability after each step. It's
possible you have a mangled/corrupted form or table/query that is breaking
the wizards.

If the blank database doesn't work (to import) make really, really sure that
the object you are attempting to import is importable (try it on another
machine, if possible).

Microsoft has an office registry cleaner automated repair utility -
http://support.microsoft.com/kb/290301
You might want to take a look at that.

Still no joy, rerun the Microsoft Office installer - do a repair.

If that fails - take the PC to the 5th floor and do a drop test to the
sidewalk below... <just kidding, kinda> <grin>

I might be tempted to uninstall Office, reboot, run the registry cleaner
utility, reinstall at that point.

Hope this helps,
Gordon
 
Back
Top