I'm using ArcGIS Pro 2.4.1 advanced, and I keep getting the following "ExcelToSQLite has stopped working" error whenever I open AGP for a new or existing project. The software loads and works fine after I click "Close program". I don't get this error with any other software. Is there anything I can check or do to resolve this error? My internet searches regarding this error came up empty.
If it matters, I also have Microsoft Office 365 v 1907 for Excel and ArcMap v 10.7.0.
This would be better for the ArcGIS Pro space instead of My Esri.
You say that you get this with any new or existing project. Do you have your Favorites set up to always include certain folder connections in the projects? Do those contain Excel spreadsheets?
Even though you're not getting the error noted in Work with Microsoft Excel files in ArcGIS Pro—Excel | ArcGIS Desktop I wonder if you followed those instructions if it would resolve the message you're seeing...
On new projects, I only have the default folder connections that AGP creates. On existing projects, I may create additional folder connections, and they do contain Excel spreadsheets. I have Excel tables in some of the projects, but the error occurs even on new projects.
An update to the error dialog, I also will get the error at random times when I'm using the geoprocessing tools, like 'smooth line'. I've used 'smooth line' several times in a session on the same dataset, and the error will pop up during one of those times.
I'll post back once I've tried updating the database engine.
I'm having the same issue (when ever trying to add XY data from excel), I already have MS Access Database Engine 2016 installed on my machine (and I did re-install it as well) and still facing the same issue. Any other recommendations/solutions?
Charlotte Peters If you go to Apps and Features and search for Access, what do you see? For example, on my machine I see that I have the Microsoft Access database engine 2010 installed.
If you don't see that, or if you see the 2007 version, install the Microsoft Access Database Engine 2016 Redistributable as described in that link and screenshot above.
We've seen the SQLite error you're reporting here a few times and are interested to understand what is causing it. Can you reply to let me know if you already have a Microsoft Access Database Engine on your machine and what version? Thank you!
Well...it was nice while it lasted. Installing the latest database engine seemed to resolve the error for a short period, but getting the error again. Can't seem to tie the error to any particular action yet. A co-worker is having similar issues, but with ModelBuilder. I haven't received the error with ModelBuilder.
My system versions:
I am encountering a similar issue. I receive the error when I am trying to use the Excel to Table geoprocessing tool. It doesn't happen when I run Table to Excel. I am running windows 7 and ArcGIS Pro 2.4.2. I installed the Microsoft Database Engine 2016, using the quiet mode, and the problem persists. If I keep the same session running, I sometimes continue to get the error message whether I am running the tool or not.
I'm also seeing the same error "ExcelToSQLite has stopped working" when trying to navigate to/open an excel file to add as a table to ArcGISPro 2.4.2 - anyone have a better solution? I've updated the MSDBE to 2016 and am on Windows 10...I also get a "catastrophic failure" error when this happens, that's cute.
I too have been experiencing the same issues as Michael August I had this problem at one point with windows 7. It had not been a problem for some time. I've updated the MSDBE to 2016 and am on Windows 10 now and the problem has returned. This happens often, when opening and expanding an excel workbook in catalog view, adding excel table to map, and now even running XY Table to Point on a table that was imported into a geodatabase is also throwing the error. I have numerous errors recorded in the event viewer that look similar to this:
Any solutions that have worked Kory Kramer?