We have a working VB.Net app that connects to an Excel file using DSNLess ODBC/ADO. It has been working for years with the normal installed office (2010, 2013, etc) 32 bit excel.

However for Office 365 if fails with an error 3706 provider not found. This has occurred on several systems. We cannot get it to work on any Office365 system.

Excel is still 32 bit. Our App is 32 bit.

connection string

Provider=Microsoft.ACE.OLEDB.12.0;DATA SOURCE='C:\Users\Lisa\Desktop\BuySell Program\Database.xlsm'; Extended Properties="Excel 12.0 Xml;HDR=YES"

Any Ideas???