Import Excel 2000 file into Acess 97

A

ann

I'm currently using Excel 2000 and Acess 97. I have tried
to import the excel file into Acess but I can't find the
excel file of type in the Import command. I've re setup
my Access to include all other file type but still problem
not solve. can any one help.
 
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.
 

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

MS Project Import Error Row 1 Column 5 2
Problems Importing Excel Data to Acess 1
How can I import file .xlsx (excel 2007) to Access 2003? 2
How to display the merge function "url" of a picture? 0
Merging from an Excel file with graphics 1
Autonumber field in Excel that behaves the same as Access 0
Active Content in this file is blocked issue 1
Import Excel 2010 table into Access 2010 - not listed as range 0

Top