missing save as extensions

[david.rainey]

I have a user that has both Office 2003 and Office 97 on her pc. When
opening a form within an access2k3 database I can save it as an excel
file. However if I open an access97 database and go to save as/export
the option to save as an excel file (of any sort) is missing. I have
tried reinstalling both, and each seperately but I continue to have the
same problem. On my pc I have office2k3 and only access97 and it the
save as excel (xxxx) option is available. Does anyone have any ideas
why the excel options would be missing from her access97 save as/export
options? Would this have anything to do with having both versions of
excel (2k3 and 97) on her pc?

Thanks.

 

[Guest]

If I remember correctly you had to do a custom install of Office Pro 97 and
basically select all options especially those that said something about data
conversion.

 

[John Nurick]

The first thing to do is to re-register the DLL that Access 97 uses to
import/export from Excel:
msexcl35.dll

If any other file formats are missing from the list, re-register the
corresponding files:
msxbse35.dll (dBase)
mspdox35.dll (Paradox)
mstext35.dll (Text, CSV, tab-delimited))

In Access 2000 to 2003, the filenames contain 40 instead of 35.

Here's one way of re-registering a DLL:

1) Locate it (usually all these are in the Windows\System32 or
WINNT\System32 folder.

2) Locate the file regsvr32.exe.

3) Drag the DLL file's icon onto the regsvr32.exe icon.