topic Re: Introduction and Error Question in ArcMap Questions

Introduction and Error Question

RobertScardamalia — Fri, 03 Sep 2021 00:04:20 GMT

General ArcGIS novice and basically use if for thematic mapping of Census and other demographic data. I'm a demographer and former State Demographer of New York State. Still do some demographic consulting through my company RLS Demographics.

I've done numerous straight joins for Excel data to layers with now difficulty. Latest effort was a couple of months ago joining a spreadsheet with 50+ Census variables to a state layer for the entire U.S. Worked fine as it always used to. Today I'm doing a similar join with only a dozen variables for all NYS minor civil divisions. Repeatedly get this error. Any suggestions on why I'm getting it all of a sudden and how to fix it?

Re: Introduction and Error Question

Anonymous User — Fri, 03 Sep 2021 00:54:07 GMT

Hi Robert, What ArcGIS product are you using?

Re: Introduction and Error Question

RobertScardamalia — Fri, 03 Sep 2021 01:24:43 GMT

10.8.1 desktop

Re: Introduction and Error Question

JayantaPoddar — Fri, 03 Sep 2021 04:50:44 GMT

Please share the Esri product and version, as mentioned by Leslie.

Close all ArcGIS and MS Office applications. Install Microsoft Access Database Engine 2016 Redistributable . If you are using ArcMap or ArcGIS Pro 2.4, install the 32-bit application. If you are using ArcGIS Pro 2.5 or later, please choose 64-bit application.

For more information, please check Work with Microsoft Excel files in ArcGIS Pro

Check if the issue persists.

The other options are

- Excel to Table Geoprocessing tool

- Save the Excel as a CSV.

Error: Failed to connect to database. An underlying database error occurred. Class not registered