I'm trying to import an XLSX file into SSMS v18.9.2. My version of Office is 365 for Enterprise.
When I try and import the file I get the error "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data)".
I've seen elsewhere that the solution is to download the Access Database Engine. I downloaded the 64 bit one, installed it, and it didn't fix anything. When I try and install the other (32 bit) version it gives me a message "Cannot install the 32 bit version because you have 64 bit Office products."
So... stuck at the moment. Any help is appreciated -- thank you!