Can't import data from Excel

  • Thread starter Thread starter Maryann
  • Start date Start date
M

Maryann

When I execute the Get External Data command so that I
can import data from an Excel spreadsheet, Excel is not
listed in the file types and I am thus unable to import
the data. In fact, nothing is listed except XML and ODBC
Database. How can I fix this problem?
 
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.
 
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.
 
Thank you - it worked like a charm. I couldn't get
msxbse40.dll to run but the others did. The one I needed
was Excel - so I am happy!! Thanks a lot.

Maryann
 
Back
Top