I'm using ArcMap 10.8.2 to deal with geospatial data stored in excel. However, I got an error named "Error: Failed to connect to database. General function failure Unexpected error from external database driver". To be more specific, I think there is a connectivity problem with my excel table to the software.
I've tried several solutions.
I've tried all possible solution I can find on Internet, and I wonder how I should solve this problem. Thank you!
What's the issue with CSV? Usually I find if numbers are coming across as text fields in arcmap, just open the CSV in notepad++ and resave, or try saving as text file and this magically solves it.
The problem is that sometimes I need to convert numerical FIPS data into text format in Excel to make joins with shapefiles in ArcMap. However, if I save the xls table with text formatted FIPS data to csv file, it will be automatically converted to numerical format again (in the new csv file), so that I cannot make my joins.
And I just tried the two solutions you recommended:
Thank you for your suggestion, and I wonder if there is an alternative solution to this prolem.
Hi @YiZeng ,
You need to install Microsoft Database Engine for ArcMap to read the Excel files. This is quite a common issue with ArcGIS Desktop.
Check out the following which should help resolve the issue
1. Understanding how to use Microsoft Excel files in ArcGIS
2. Microsoft Access Database Engine 2016 Redistributable
I hope this helps!
The latest KBB our IT installed broke this on my Windows 10 system. Tried to re-install the redistributable, but installer closes out without installing as I now have 64 bit version of Office on my computer (ArcMap needs the 32 bit Redistributable package).
To work around this issue, use the command line installer in "quiet" mode and it will install the 32 bit version.
However, don't have Widoze 11 to test this on.
Try saving the file as a .xls file and format the fields just as you need them. Then open the conversion tool box > Excel and try using the Excel to table tool.
Is it possible for you to upload your excel data here?
Doesn't seem to matter what formatting is set in Excel, ArcMap tends to look at the first row of data in the Excel/csv file to determine format (not the header row, but the next one).
Make sure that the first line of data is a number only for numeric fields, and text only for text fields and that none of the values on the first data row are empty.
Once imported into ArcMap, you can delete the first row of "tmp data".
If you save the info as XLSX, any numeric field saved as text, will be respected as text.
ArcGIS can read both XLS and XLSX files, but you may need to install an additional driver on your machine, depending on what version of Microsoft Excel you are using.
I hope this helps 😄