importing excel file from MS Access

[fratezone]

Our IT dept just reloaded MS Office and now I can't import excel files into Access. When I click on the GET EXTERNAL DATA button and then click on IMPORT, I get the usual dialogue box listing the file types with the exception of excel files. I installed and re-installed ALL selections having to do with Access and Excel and Data Access files using the Value Pack CD and still no changes.

Does anyone have any idea what is missing?

Thanks

MS Access 97 / Windows 98

 

[Jeff Bailey]

Mike

I had this exact same problem a while ago - and it drove me nuts until I asked in a newsgroup and a wonderful lady named Martha sent me this (which fixed the problem completely):

"Sounds like your DAO library got un-registered somehow. (Office 97 installation doesn't register it properly in the first place, so re-installing is no help.)

Go to Start menu|Run, type the following, and click OK:

regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\dao350.dll"

You can also check to make sure your references are ok (open any code module, go to Tools menu|References, and make sure nothing is marked "MISSING").