.xlsx import, Microsoft driver no longer avaliable

Question

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

CatherineReynolds · Answer

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

danretired · Answer

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

CatherineReynolds · Answer

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