topic Re: .xlsx import, Microsoft driver no longer avaliable in Data Management Questions

.xlsx import, Microsoft driver no longer avaliable

CatherineReynolds — Wed, 06 Jan 2021 11:08:31 GMT

Hi All,

I've seen a few people mention problems with importing .xlsx files and the solution seems to be to instal the 2007 Microsoft driver. However, this is no longer avaliable to download.

There must be a simple way to use .xlsx files in ArcMap 10.7, surely! I'd love to know another way other than saving each excel in the old 2003 .xls format.

Thanks in advance!

Cat

Re: .xlsx import, Microsoft driver no longer avaliable

DanPatterson — Wed, 06 Jan 2021 12:00:28 GMT

If you are using windows 7... upgrade to windows 10

Work with Microsoft Excel files in ArcGIS Pro—ArcGIS Pro | Documentation has an option for drivers

upgrading to ArcGIS Pro would be a good step as well

Re: .xlsx import, Microsoft driver no longer avaliable

CatherineReynolds — Wed, 06 Jan 2021 12:44:58 GMT

Hi Dan,

Thanks for the suggestions. I am using windows 10 so that wouldn't help. I just downloaded the Database engine you suggested and restarted my computer but this has actually made things worse. I now can't open the add data feature, it comes up with the error message: "Failed to connect to database. An underlying database error occurred. Class not registered." Any idea why this happened, or other suggestions?

Thanks,

Cat

Re: .xlsx import, Microsoft driver no longer avaliable

DanPatterson — Wed, 06 Jan 2021 13:05:01 GMT

Error: Failed to connect to database. An underlying database error occurred. Class not registered (esri.com)

Solved: Failed to connect to database. Underlying DBMS err... - GeoNet, The Esri Community

pop up as issues and recommendations

Note arcmap is 32 bit NOT 64

Re: .xlsx import, Microsoft driver no longer avaliable

CatherineReynolds — Wed, 06 Jan 2021 14:49:17 GMT

I did download the 64 bit version. i'll uninstall and try again. Thanks!