Exporting to Excel

[Guest]

I have just re-installed Office 2003 on my PC and have no longer got an
option to export to Excel under the export file types. Have tried repairing
Office, but to no affect. Any suggestions about how to get export to Excel
back again.

 

[Joseph Meehan]

I have just re-installed Office 2003 on my PC and have no longer got an
option to export to Excel under the export file types. Have tried
repairing Office, but to no affect. Any suggestions about how to get
export to Excel back again.

Sorry if I am repeating the obvious, but it sometimes is staring you in
the face.

You do have both Access and Excel installed and functioning on the
machine.

You have a query or table open that can be exported to Excel when you
are trying this.

 

[Guest]

Yes I have both installed and I am using the same way as before. Before I
re-installed there were at least 10 options on the file type menu, now there
are only 7 - export to a text file is also missing.

 

[Ken Snell [MVP]]

Re-register the following files:
msexcl40.dll (Excel)
msxbse40.dll (dBase)
mspdox40.dll (Paradox)
mstext40.dll (Text, CSV, tab-delimited))

Also, try re-registering this file:
Accwiz.dll

To re-register a DLL file,

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.

Or run from Start | Run window (example):
Regsvr32 "path\msexcl40.DLL"

etc.