When trying to join Excel datafile to shapefile in ARC GIS 10.2.2 I keep getting the following message: "Failed to connect to database. An underlying database error occurred. Class not registerd." Any ideas how to resolve?
First, open the Excel file in Excel, and then click Save As and select CSV (Either Macintosh or MS DOS works for this purpose) Next, in ArcMap, choose the tool Table to Table and for the input, choose the CSV you just created. Have it output somewhere you can find the table, and the joining should work with the table that was just created.
TL;dr: Save Excel file as a .CSV, use Table to Table tool to convert the .CSV into a .DBF.
you need to install the 2007 Office System Driver. It can be downloaded from the Microsoft Download Center. If you do not have any version of Microsoft Excel installed, you must install that driver before you can use either .xls or .xlsx files. If you have Excel 2010 installed, you must still install the driver.
First of all, make sure your excel table is "clean". This may seem obvious, but you'd be surprised...Here's an example of what kind of things you should avoid:
Just with this precaution it should work. However, if it's still not working, use the conversion tools. Conversion tools>Excel>Table to excel and import your excel into a gdb. That should work. If it's still not working, make sure your join fields have the same properties.