arcgis-10.5arcgis-desktopexcel
Background: I'm using GIS tutorial basic workbook (ArcGIS 10.1) with ArcGIS 10.5 software, and my MS office is 2010
I was practicing building a file geodatabase, and I have imported shapefile without issue, but I couldn't import the data table (.xlsx). The error message keeps popping up saying "Failed to connect to database. An underlying database error occurred. Class not registered".
I'm still fairly new to using the software so I'm not sure what went wrong.
When adding table information from any source to arcmap, selecting the add xy option,
Arcmap programmatically converts the data (internally) to a spatial type and displays it on your map with the xy coordinates in the projection you choose.
When you select any data source and right click and choose export data there are no options to modify the output field type/s.
In order to accomplish this task so that you have EXACTLY the field type you want.
Create an empty shapefile (utilizing steps 1-3 below).
Steps 1 and 2 keep you from having to manually add all your fields.
Import brings them in from your mdb.
This will provide a container with the correct field types in a shape file.
Then steps 4 and 5 will export the data with the wrong field types and you load that data into the container with the right field types.
Use these esri resources help pages to understand limitations and uses.
Data Type in the DBMS
ArcGIS Field Data Types
1.) create a new file geodatabase in arccatalog and on the field tab use the import feature.
2.) select the original file. (your accdb)
3.) modify the field type to exactly what you need.
4.) export the data to a scratch shapefile. (or better yet file gdb.
5.) Load the data using simple loader to the file gdb you created with the specific fields.
Make sure of these points:
Best Answer
Two easy solutions:
1) Save the XLSX file as an older XLS version via "File|Save As" in Excel and select "Excel 97-2003 Workbook (*.xls)" as the file type. This should work with any version of Excel installed, which is required.
2) Download and install the 2007 Office System Driver: Data Connectivity Components from the MS Download Center. This is required even when working with Excel 2010 or 2013 to natively work with the XLSX files in ArcGIS. Should work immediately after installing.
One other tip when working with XLS/XLSX files, load the excel file into your MXD using "Add Data". Then proceed with joining the table to your other features using the loaded reference rather than pointing to the file directly.