MS Access 97 Importing from MS Excel

[KMITCH]

.xls is not showing up as an option in the Import
window in MS Access 97. We are following the directions
to remedy this by going through the Add/Remove, Date
Access, Change Option but this is not helping. When
it gets to the Drivers window, it shows the Microsoft
Excel Driver as already installed as well as the Text
and HTML Driver.

Any ideas?

Thanks,
Keith

 

[gwinn7]

If you are re-installing Office, you could try a shot-gun approach and click 'Select All' for all programs and components, then remove which options/programs ones you are sure you do not want. Hopefully, that would work.

Gary
gwinn7

 

[KMITCH]

A friend found the answer for me on HelpTalk. Thought I
would post it here for the sake of completeness.
...


Problem: lost export to file types

This is a problem that can drive you up the wall trying to remedy if you don't know the reason and the fix.
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.
Possible .dll files that need to be reregistered.
1. mstext.dll
2. msexcl35.dll
3. msxbase.dll
4. msltus.dll
Here is how you reregister the .dll files.
First shut down any MS Office programs that are running.
From the Desktop, click the Windows Start Button, choose Find, then Files or Folders.
Type this for the files to be found (with the commas):
regsvr32.exe,mstext35.dll,msexcl35.dll,msxbase.dll,msltus35.dll
Click "Find Now", this will locate the needed files (you may have more than one regsvr32.exe, but this is OK).
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.




...