I am trying to use a .xlsx file as a database, but im getting the error External table is not in the expected format. I have used the below code for connection string
string connstr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source="
+ inputExcelPath + ";Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1\";";
OleDbConnection conn = new OleDbConnection(connstr);
User contributions licensed under CC BY-SA 3.0