I have been trying to access 2016 msMS Excel file using c#C#, but connection string is working only till 2013 ms excelMS Excel.
myMy current connection string: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx; Extended Properties="Excel 12.0 Xml;HDR=YES";
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx; Extended Properties="Excel 12.0 Xml;HDR=YES";
isIs there any modified oledb connection string for ms excelMS Excel 2016?
any help would be appreciable, thanks in advance.