Software

Ask something
Discussion Locked

Access 97 will not import an excel file

0 helpful
7 replies

by dana803

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
After a reinstall of Access 97 (Office Pro) after getting a VBA error, now when going into File...Get External Data, an xls file is not an option in the file types box so we can't get an Excel spreadsheet imported. The Excel driver is in the ODBC in control panel. We also uninstalled and reinstalled Office 97 Pro. When using the Custom install, the option to check the Excel driver in Data Access is greyed out and says Installed to the right. I don't know what else to try. We installed Access 2002 and that fixed the problem, but the databases are shared with other users who use Access 97 and they don't want to upgrade. There must be a way to fix this.........

7 replies

by murray_g

Did you try saving the database as a previous version? I believe access 2002 is backward compatible.

by dana803

The users decided to all upgrade to 2002 because they didn't want the hassle otherwise.

by jmiller1

Once Access 2000 fixes the problem, save the db as a 2000 mdb file. Then click Tools->Database Utilities->Convert Database->To Prior Access Database Version. This will let you resave the db as a '97 version mdb. Then redeploy to your users.

by dana803

The users decided to all upgrade to 2002 because they didn't want the hassle otherwise.

by lizzy

I think the first two answers are correct saying to save your data base as a previous version. I did recently install some new PC's here at work and I had to "downgrade" the office from XP to a previous version so they could maintain access to a customer data base that would not be accessible to other users not being upgraded to new machines at this time. Office 2000 -is- backwards compatible to 97. Office XP\2002 -is not- backwards compatible to 2000 or 97. The Access program told me that when I tried to convert the 97 database to XP. It specifically said it would no longer be accessible to Office 97 or 2K users once converted to XP!

If you cannot save as a previous version, you may have to restore from backup and start from there.
HTH

by dana803

The users decided to all upgrade to 2002 because they didn't want the hassle otherwise.

This discussion is closed to new replies.