Can't import data from Excel

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?
 
J

Joe Fallon

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

Joe Fallon

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

Maryann

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
 

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

Can't import external data in Access 2003 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Bringing in data from excel 6
file types missing when importing tables from excel 2
I can not import any Excel Spreadsheet! 6
Import Data from Excel 2
Import from Excel 1
How to Import data from Excel into a single table 2

Top