Access 2003 - Import Spreadsheet Wizard not working

G

Guest

Hello, I'm using Access 2003 and can't get the Import Speadsheet Wizard to
work.

I go File -->> Get External File -->>Import --Pick the excel file I want and
press Import but nothing happens, The Import Speadshhet Wiard does not show
up.

Any clues?

Thanks
 
J

John Nurick

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I can not import any Excel Spreadsheet! 6
Access Subscript out of range when importing into access 2010 from excel 0
Access Import Wizard not working 0
No *.xls selection to import 3
Import wizard unable to access information for Excel spreadsheet 0
access import wizard doesn't import all rows of excel file 1
Import Spreadsheet Wizard 10
Access 2007 import failure 4

Top