Importing from Excel

  • Thread starter Thread starter Mano
  • Start date Start date
M

Mano

I am using ACCESS 2000 / Windows 2000 Professional.

Importing an Excel spreadsheet does not go through all the
step but completes before that.
This is what happens
1) Lets me select Excel file to import
2) Immediately comes back to the screen that I started
import from...does not go through the options to select
the table to import too etc.
Any help would be appreciated.
 
Hi Mano,

The first thing I'd try is to re-register ACCWIZ.DLL, and then
msexcl40.dll

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.


These problems are discussed in the following MS Knowledgebase articles
among others:
http://support.microsoft.com/?id=292269
http://support.microsoft.com/?id=155666
http://support.microsoft.com/?id=171955
or for Access 2002
http://support.microsoft.com/?Id=283881
 
Thank you John.
We re-installed ACCESS and that fixed the problem.

-----Original Message-----
Hi Mano,

The first thing I'd try is to re-register ACCWIZ.DLL, and then
msexcl40.dll

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.


These problems are discussed in the following MS Knowledgebase articles
among others:
http://support.microsoft.com/?id=292269
http://support.microsoft.com/?id=155666
http://support.microsoft.com/?id=171955
or for Access 2002
http://support.microsoft.com/?Id=283881

I am using ACCESS 2000 / Windows 2000 Professional.

Importing an Excel spreadsheet does not go through all the
step but completes before that.
This is what happens
1) Lets me select Excel file to import
2) Immediately comes back to the screen that I started
import from...does not go through the options to select
the table to import too etc.
Any help would be appreciated.
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
 
Back
Top