I am trying to load an Excel spreadsheet into ArcMap 10.6 in Windows 10. But it will not load and this is the error message:
ArcGIS – Failed to Connect to Database Error When Loading Spreadsheet: Class Not Registered
arcgis-10.6excelimport
Related Solutions
Do you receive the same error by copy/pasting records?
This is from memory, but if you right-click on the gray row indicator box, your menu should have "Copy Selected Records". Then you can paste directly into an Excel spreadsheet.
A caveat: if your selections are in a related table that are a result of a feature selection, you might actually have incorrect selections (you get rows in your related table that aren't actually related to any of your selected features and you could be missing others). One of my users discovered this issue, which appears intermittent. I did narrow down the issue to ArcMap. The geodatabase+custom ArcObjects test code works correctly. Our workaround: if our users need the related data for something important and the number of records is too large for them to visually inspect, we obtain the data from the database using a sql query. We haven't seen this issue with ArcGIS 10.
Update: You said you got the data into Excel. Are your DMS values in a text field? You might be able to parse the information that you need and round your decimal value. based on what I see in your screen shot, i came up with:
=LEFT(A1,8) & ROUND(VALUE(MID(A1,9,6)),1) & MID(A1,15,2)
You can not pip install rasterio on Windows. There are no binary wheels for Windows on the Python package index. You must use the binary wheels published by Christoph Gohlke (as explained in the rasterio readme), or use Anaconda and the conda-forge packages.
Best Answer
I have encountered this error a few times. There are a few potential causes.
First this to check...do you have any versions of the Excel Document Open at all?
Try shutting down all instances of ArcMap and Excel and then restart ArcMap and try again opening the Excel document again. I have found that ArcMap and Excel do not like having the same spreadsheets open at the same time, so any instance of this occurring can cause issues. If this doesnt work, it may be an issue that arose from the switch in Excel Versions a few years ago.
A solution I have used is found on this website: https://community.esri.com/thread/183010-after-windows-10-upgrade-attempting-to-use-an-excel-file-xlsx-file-crashes-arcmap
The link on the site points to a Microsoft Fix for installing components from Office 2007, which seem to have not made the cut in the change in versions.
https://www.microsoft.com/en-us/download/details.aspx?id=23734
Try installing the fix and you should be back in business.