Importing EXCEL data

  • Thread starter Thread starter Sandy
  • Start date Start date
S

Sandy

File>Get External Data >Import - *.xls is not an option.

I first tried to remove and re-install Access from my CD.
Then I have tried to install Data Access Pack from the
Office 97 CD (following the procedure per VALUPK8.HLP) a
few (3) times and have been unsuccessful. I tried to do a
re-install. When doing the installation I check
everything even though I only need to import information
from Excel. In every case the message displayed on the
screen was that the installation was OK.

{ I have Office 97PE, however ..System Tools > System
Information says I have Word 2000, Excel 2000, Access
2000, PP 2000. I do have FrontPage 2000 installed}
Thank you
 
Try re-registering the dll files like this:
Start Run
regsvr32 msexcl35.dll
regsvr32 msxbse35.dll
regsvr32 mspdox35.dll
regsvr32 mstext35.dll

Use 40 instead of 35 for A2K and 2002.

That's MSEXCL35.dll not MSEXC1.dll.
 
From info previously posted by John Nurick, Microsoft ACCESS MVP:

If the import/export wizards don't work at all, 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.
 
Back
Top