OLEDBconnectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\User\Documents\file.xlsm;Extended Properties='Excel 12.0 Macro;HDR=YES';"
"'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine." How do you register 'Microsoft.ACE.OLEDB.12.0' on my local machine?
OLEDBconnectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\User\Documents\file.xlsm;Extended Properties='Excel 8.0 Macro;HDR=YES';"
OLEDBconnectionString="Provider=Microsoft.JET.OLEDB.4.0;Data Source=C:\Users\User\Documents\file.xlsm;Extended Properties='Excel 4.0 Macro;HDR=YES';"
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsm; Extended Properties="Excel 12.0 Macro;HDR=YES";
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)