Access 2003 - Import Spreadsheet Wizard not working

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Don - 28 Mar 2006 23:30 GMT

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

Reply to this Message

John Nurick - 29 Mar 2006 05:31 GMT

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.

>Hello, I'm using Access 2003 and can't get the Import Speadsheet Wizard to
>work.
[quoted text clipped - 6 lines]
>
>Thanks

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message