-
Title
Retrieving the COM class factory for component ... failed due to ... 800700c1 is not a valid Win32 app -
Description
In Toad Data Point (TDP) by executing: Right Click on the Data Grid | Quick Export | Excel Instance | Excel Instance
One may see the error:
Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 800700c1 is not a valid Win32 application. (Exception from HRESULT: 0x800700C1). Export is cancelled.
Having: TDP as a 32bit APP, and Microsoft Office 365 ProPlus 32 bit.
Being able to: connect to Excel Files, Export into files but not Instances.
Also having installed the Microsoft Office Access database engine 2007, and the Microsoft.Office.Interop.Excel version 15.0.0.0 in "C:\Windows\assembly".
--
In the Windows Event Viewer it is possible to see the error
Unable to start a DCOM Server: {00024500-0000-0000-C000-000000000046}. The error: "193"
Happened while starting this command:
C:\Program Files (x86)\Microsoft Office\Root\Office16\EXCEL.EXE /automation -Embedding
-
Resolution
Uninstall the Microsoft Office Access database engine 2007, and, download and install the Microsoft Access Database Engine 2010 Redistributable (32 bit).