topic Re: ExcelToTable Conversion Issues in ArcGIS Pro Questions

ExcelToTable Conversion Issues

AndrewCooksey — Wed, 24 Mar 2021 18:43:11 GMT

I am trying to convert an Excel to a table that I can upload to server and eventually to relate it to a feature service to provide updates to issues that are related to a located asset. I have been running the ExcelToTable tool and identifying the Excel file and indicating the .GDB, but after it runs I get the error

"ERROR 160706: Cannot acquire a lock.
Failed to execute (CreateTable).
Failed to execute (ExcelToTable)."

I have attached a jpeg of the full message. Also attached is the file I am trying to convert.

Re: ExcelToTable Conversion Issues

kkoz490 — Wed, 24 Mar 2021 19:39:48 GMT

This may mean that someone or application is accessing the file. Make sure that the file is closed and any other ArcGIS applications are closed. Esri maintains many things in memory. This causes database locks.

Re: ExcelToTable Conversion Issues

Robert_LeClair — Wed, 24 Mar 2021 21:42:34 GMT

It worked fine for me. See attached. My guess is there's a lock somewhere in the system. Could be unsaved edits in ArcGIS Pro, could be the Excel spreadsheet is open by another use. My recommendation is save your AGP Project, close it, close any open Excel applications, reopen the ArcGIS Pro project and try the tool again. What is the result?

Re: ExcelToTable Conversion Issues

DanPatterson — Thu, 25 Mar 2021 00:18:07 GMT

Work with Microsoft Excel files in ArcGIS Pro—ArcGIS Pro | Documentation

contains a number of recommendations.

pay attention to those regarding sheet names containing unsavory characters and/or spaces.

The shutdown and reboot is generally a good all around starter as has been suggested.

Re: ExcelToTable Conversion Issues

AnnieTH — Thu, 25 Mar 2021 07:21:10 GMT

I also suggest changing the file name. Don't ever start with a number, no special characters, no spaces. The other suggestions sound good too. Let us know what works!

Re: ExcelToTable Conversion Issues

AndrewCooksey — Thu, 25 Mar 2021 13:32:27 GMT

Still getting the same results. I updated the Excel spreadsheet filename, updated the field names and tab name so that none of these had spaces or started with a number. I also attempted to run the tool ArcGIS Desktop 10.4 ArcCatalog as well as ArcGIS Pro. When I got the same results, I restarted my PC and re-ran the tool with the same results. As another couple trials I also tried copying the data out and pasting it in a new Excel file as text. Also tried running the tool with a .CSV file and and older Excel .XLS file. Attached are the latest results and the revised Excel file.

I am starting to wonder if there was an install error somewhere, but I was able to successfully run this tool in the past with no issues.

Re: ExcelToTable Conversion Issues

Robert_LeClair — Thu, 25 Mar 2021 15:45:59 GMT

Try this - copy the *.xlxs file to your C: drive - say a C:\Temp directory - try the workflow again. What is the result? In my earlier test, I had no error message converting the Excel file to *.gdb table.

Re: ExcelToTable Conversion Issues

AnnieTH — Thu, 25 Mar 2021 19:45:35 GMT

Another option to try would be to use Google Sheets to convert the file to .csv. But, I understand you are also trying to figure out why it didn't work!

Re: ExcelToTable Conversion Issues

MicZatorsky_AEC — Thu, 25 Mar 2021 21:11:03 GMT

Which version of Pro are you using?

What type of storage is your data on? Local HDD, network share, cloud-native file service?

Re: ExcelToTable Conversion Issues

AndrewCooksey — Thu, 25 Mar 2021 22:24:40 GMT

At first I did not think that this worked as I still got the same error. However, I went back and tried again, this time with both files being located or saved to a place on my C: Drive. Once I did that it seemed to work no problems. Last time I tried this, I do not remember having to work locally first before moving it over to my server.