I want to extract data from excel file using sql query.I have excel 2016 and i have installed Microsoft access database engine 2016 .
I have used following connection string:
“Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\Greysoft\EnelX Uipath Project\EnelX_ElkEnergy_REFramework\Data\Status.xlsx;Extended Properties=‘Excel 12.0 Xml;HDR=YES;IMEX=1’;”
But I am getting error as System.Nullreference.exception
Please help me in this .