I have a problem importing excel (and others) into Access 97.
The problem is not that simple - I know that I can add/remove using setup choose data import, select all and all should be well. One problem there that is when you do this the options for excel, html and text imports are greyed out and state "already installed". Ho hum.
To make matters worse because I work as a helpdesk for computer problems I have multiple databases and systems installed on both my main machines (home and office). I have installed Office95, Office 97 and Office 2000. clearly the problem lies with the import filters for these three. As a matter of interest the import works perfectly on Office 2000, I do not need to use the import facility on Office 95 but I do require it on Office 1997. I have installed the patch to enable Office 97 to work with Office 2000.
Anybody any ideas.
I have already removed all applications and reinstalled them in a different order but no avail.
I know it's been over 7 years but now (after installing Access 97 on a new computer) I have the same problem. Excel is no longer a choice in the list of file types. I've uninstalled/reinstalled everything I can think of. Can you tell me the answer? Thanks!
Thanks for a quick reply. If you mean what mine shows as Data Access, I've tried that many times. I highlight it, then click on Change Option..., then Database Drivers, Change Option.... The final selection screen shows Microsoft Excel Driver which is checked BUT the checkbox is gray indicating only part of the component will be installed. Somehow I can't help thinking that the part that is NOT installed is creating the problem. But I have been unable to eliminate the gray.