ArcGIS does not open Excel (*.xlsx) files
This issue also exists in the software development process, which is required when *.xlsx cannot be read.
1.ArcGIS Error:
Failed to connect to Ddatabase. An underlying database error occured. No registration class
2. Reason:
Missing the Office System driver (AccessDatabaseEngine.exe)
3. Solution:
Need to install the Office System driver (AccessDatabaseEngine.exe), download the English point here, the Chinese version here, the official description of this package is as follows:
This download installs a set of components that non-Microsoft Office applications can use to read data from the Office system files, such as from Microsoft office Access (MDB and accdb) files and read data in Microsoft Office Excel (xls, xlsx, and xlsb) files. These components also support establishing connections to Microsoft Windows SharePoint Services and text files.
In addition, ODBC and OLE DB drivers are installed for application developers to use when developing applications that are connected to the Office file format.
PS. If this component is not installed correctly, refer to the following two reference processes in part fourth.
4. Reference Links:
ArcGIS Desktop and Excel. NET using Access Database to read Excel notesSolutions for installing Microsoft Access engine in a 64-bit Win7 operating systemAuthor:allenrobin http://gisrsman.cnblogs.com
arcgis/c# development cannot read Excel (*.xlsx) files