Microsoft.ACE.OLEDB installed, but not working
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?
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By mp3909 in forum Excel Programming / VBA / Macros
Last Post: 10-12-2020, 09:40 AM
By yodeys in forum Excel Programming / VBA / Macros
Last Post: 05-22-2018, 02:33 AM
By toiDy in forum Excel Programming / VBA / Macros
Last Post: 03-21-2016, 02:01 PM
By nichchap in forum Excel Programming / VBA / Macros
Last Post: 07-18-2014, 08:36 AM
By maacmaac in forum Excel General
Last Post: 07-29-2008, 03:56 PM
By MalcolmW in forum Excel General
Last Post: 08-03-2005, 07:05 PM
By SJB567 in forum Excel Formulas & Functions
Last Post: 05-14-2005, 02:06 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1