export to excel not listed

[mike]

I am trying to export a query in acces 97 sr-2 to excel
97. When I click on the files options excel is not
listed. I went through the value pack on the cd and still
could not find what I needed.

Can you tell me what steps to take to get excel 97 to
show up as an export option? I have the sr-2 cd. When I
click about in excel it shows sr-2 and in then a set of
(). In the () is a straight vertical line. I don't know
if this is causing a problem.

I moved to a new computer and reinstalled excel.

Thanks,

Mike

 

[Douglas J. Steele]

Sounds as though this might be the problem discussed in the following KB
articles:

http://support.microsoft.com/?id=155666
http://support.microsoft.com/?id=171955

Look for the file msexcl35.dll on your hard drive (it should be in the
System folder), and use regsvr32.exe to reregister it.