ACE OLEDB provider in vbscript in HTML application (hta) to read an excel says provider not installed, vbs is working but hta is not working
I want to read an excel sheet and display the contents with vbscript. The ACE OLEDB providor has to be used (please don’t ask, I know this is end of life and not sustainable etc, but I cannot change this right now), so I installed the Microsoft Access Database Engine 2016 Redistributable (accessdatabaseengine_X64.exe). Furtermore I have Microsoft 365 Apps for Enterprise installed (x64) on my laptop with Windows 11.
I created an excel file with 1 sheet, 2 columns and a few rows of content like this: