Windows Forum

Ask something
Discussion Locked

Problem with Microsoft Access 97

0 helpful
3 replies

by dave.raj

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi I know I am in the wrong section, but I m having an annoying problem with Access. When I start a new database, and I want to get an external database and when i go to choose the type of file, there is not an option for excel files. I have uninstalled and reinstalled microsoft office 97 PE and still no luck. Also tried to convert Excel file into an Access file and it will say on the screen that it has been converted but there is no evidence for it. Can someone pls help because it will be really appreciated.
Cheers:-)
Dave

3 replies

by magetower

Make sure you have the database drivers for Excel loaded.

Rerun the Office setup from Control Panel/Add/Remove Programs.

Select Add/Remove Options.

Scroll down to Data Access and click the Change Options button.

Select Database Drivers and click Change Options.

Make sure the Microsoft Excel Driver is checked. If not check it and continue with setup. This should fix the problem.

If it is checked, uncheck it, continue setup, restart the system (I have found a reboot after an Office config change to be helpful especially when removing features), then go back to setup and recheck the option to reload it.

Hope this helps...

by dave.raj

thanx, as soon i wrote the question i looked on the microsoft website and found the solution that u just gave me.

Cheers:-)

Dave

This discussion is closed to new replies.