nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Error HRESULT: 0x80040501 when adding excel files

IreneFernández_López

When I try to agregate an Excel File to ArcGIS Pro it comes out an error with the message: Exception of HRESULT 0x80040501.

It doesn't show any details on the error. I have already installed the Access Database Engine Controller, but I can't find where this error comes from.

Can anyone help me with this?

Thank you.

Captura de Pantalla 2020-01-14 a la(s) 7.14.25 p. m..png

タグ付けされた投稿をもっと見る

Accepted answers

VictoriaAnderson

Do you have 2 versions (64 and 32 bit) of Microsoft Access Database installed? If so, can you uninstall both versions and reinstall just the 32 bit?

All comments

JoeBryant1

To resolve the issue, I had our engineers move the complex charts and graphs they were making in separate sheets in the Excel file to another workbook that calls the data from this workbook. Once I cleared Pro's cache and reduced the Excel workbook down to a single sheet, it consistently opened.

JoeBryant1

Some employees at my org are also getting this error when trying to open an APRX with a layer joined to an excel table on our fileshare server. It works for some employees and not for others (all have access to the file). Running Pro 3.1 and 3.3.

We get "Failed to open table - The source data of the Layer or Standalone table is disconnected.

If I try to preview the sheet from the Catalog Pane, I get the error "Not running inside a server process."

If I try to add the sheet to my map's Table of Contents, I get "Error: 0x80040501".

ALESSANDRASPREAFICO

Hello all,

I get the same error when opening the project file in ArcGIS.

I have a connection to a PostgreSQL database on a remote server and I use a VPN to connect to the database.

The connection worked till last week. From another computer I don't have this error.

Is there a solution?

Thanks

TomStephenson3

I still have this issue on ArcGIS pro 2.6.4 running 32bit Access only. Please come up with a better solution than this Esri!

AlexRudowski

I'm not getting the error anymore, but I'm still having the issue where it takes forever to save. Sometimes it just spins and never saves at all 🤔

ZacharyHart

having the exact same issue still. @AlexRudowski did you ever find a solution?

AlexRudowski

I get this same error sometimes when I'm trying to save a new ArcPro project. I'm not sure what the Access driver has to do with my situation, but I checked and I only have the 32-bit version on my machine. The error message appears, but sometimes if it sits for about five minutes with the error message up the project will finally save. I'm working in 2.7.3 but will soon update to the newest version.

Thanks

AndrewDolch2

Convert the file to a CSV and then import.

AlexanderGlonti

Hello, I have a same error into ArcGIS Pro during add data from PostgreSQL. Do we have any solution in such case?

RafałRokicki

Just finished install only Standard 32 bit and still this errror

VictoriaAnderson

Could you try uninstalling the 64 and install the 32 instead?

RafałRokicki

Hello,

i have same problem and same error, but after reinstall whole Office and install Standard x64 (without Access) instead of Profesional x32 (with Access) i still have this error

IreneFernández_López

That was the problem! Thank you so much!!!

VictoriaAnderson

Do you have 2 versions (64 and 32 bit) of Microsoft Access Database installed? If so, can you uninstall both versions and reinstall just the 32 bit?

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.