Importing from Excel 2

[Fleetman]

We use Office '97 Professional. On some Pc's we are unable to import data from Excel into Access. Under Import, Files of Type only Acces and ODBC databases are listed, yet other PC's list Excel. All the PC's have been setup identically with a full installation of Office. We have reinstalled Office several times with no luck. I have read on Microsoft's support pages article no. Q160954 which says to rename Offpro97.stf then reinstall, but it made no difference. I have also installed the additional file types in the Valupack with no difference. Any ideas?  

 

[rhicks]

This is a problem that I figured out the hard way. I have not seen any documentation on this by Microsoft. Follow the instructions below on each machine giving you the problem.<br><br>Uninstalling and installing Office or Access is what commonly causes this problem. The problem is you have a .dll file that's not properly registered. You may have more than one, so I will explain how to register the most common ones. <br><br>Possible .dll files that need to be reregistered.<br>1. mstext.dll <br>2. msexcl35.dll&nbsp;&nbsp;&nbsp;&nbsp;(this is the one giving you the problem)<br>3. msxbase.dll<br>4. msltus.dll <br><br>Here is how you reregister the .dll files.<br>First shut down any MS Office programs that are running.<br>From the Desktop, click the Windows Start Button, choose Find, then Files or Folders.<br>Type this for the files to be found&nbsp;&nbsp;(with the commas): <br><br>regsvr32.exe,mstext35.dll,msexcl35.dll,msxbase.dll,msltus35.dll <br><br>Click &quot;Find Now&quot;, this will locate the needed files (you may have more than one regsvr32.exe, but this is OK).<br>Using the window you are viewing, drag and drop each .dll file on top of regsvr32.exe and release it, one at a time. This will reregister each .dll file. You should receive a message say that the registering was successful. After completion you should see these as a choice when you need them.<br><br>HTH<br>RDH<br> <p>Ricky Hicks<br><a href=mailto: rdhicks@mindspring.com> rdhicks@mindspring.com</a><br><a href= > </a><br>