I'm running windows xp and access 97 but do not have the option to import or export excel files. I did a full install of office 97 professional and also installed the valuepack, but no luck. Has anyone run into this problem before and know how to fix it?

Does it give an error or are these options greyed out?

Maybe this can help you:
=> ACC97: Unable to Import Excel Spreadsheets, HTML Files, or Text Files
or
=> ACC97: Which Wizard Is Where in Microsoft Access 97?

Greetz from Belgium

Luc aka Kuifjexx

That's what is really weird. When I go to "Get external data" or try to export a table, I click the drop down to select the format, and Excel is not even in the list...now that I look, either is text. I have everything but those two options. I read and followed the steps in the knowledge base articles above, but they didn't do the trick. Anyone have any other ideas??

Is excel fully installed?
Is access fully indstalled with all "drivers" for data-exchange with other programs

Check the ODBC Data Source Administrator

Greetz from Belgium

Luc aka Kuifjexx

Yep..I tried those options as well and still couldn't get it working. However, after reading the following page, I got it fixed. Thanks for your help.

http://www.tek-tips.com/gviewthread.cfm/le...d/181/qid/10076

Thx for the tip

Glad the problem is solved

Greetz from Belgium

Luc aka Kuifjexx