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?
Bookmarks