Hi all

I have a script which uses Microsoft.ACE.OLEDB.16 to read an Excel file. It works fine when run as vba whitin Excel on my computer, but not when run as a windows script on our server. I get the error message "Provider cannot be found. It may not have been properly installed."

So I googled the error message, and I found I must install Access database engine. I installed it, but I still get the same error message. I tried both the 64 bit and the 32 bit versions, as well as both version 2016 and 2010. Always same error.

This is my connection string:
"Provider=Microsoft.ACE.OLEDB.16.0;Data Source=" & ExcelFilePath & ";Extended Properties=Excel 12.0;Persist Security Info=False;"

Any idea why it's not working?