Problem

When the Import dialog opens and before the groups to be imported are displayed, an error occurs:

Error caught at line (unknown) in ImportDataModel.LoadGroups: 

Error HRESULT E_FAIL has been returned from a call to a COM 

component.

The error occurs for all data connectors.


Resolution

Recent Microsoft updates to Windows 7 and Windows 10 have cause ArcMap to fail when opening an XLS file. Esri have issued an article on their support site: General function failure Unexpected error from external database driver


The Microsoft Updates were: 

Unfortunately there is no workaround for Import in Player. It fails when trying to read the DataConnector (XLS file) using the ArcMap libraries. 


Player 4.2 SP1 (Build 6501) resolves the issue for Import. Reading XLS is still a problem in ArcMap until Esri/Microsoft resolve the issue. 


Additional Information

After installing the Player 4.2 SP1, if you may still get an error:

Error caught at line (unknown) in ImportDataModel.LoadGroups: 

Exception from HRESULT: 0x80040213

Or:

Error caught at line (unknown) in ImportDataModel.LoadGroups: 

XLSX EXCEL file format is not supported on this machine. Please

contact GIS-pax Support for assistance.


ArcMap 10.1 to 10.5 requires an additional Microsoft library to open Excel XLSX files. The download is available here: