Getting Null reference error while executing sql query to read data from excel 2016 .xlsx file

Hi,
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 .

Thanks,
Supriya

can you try the 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 8.0;HDR=YES’”

ok I will try

Hi,

I have tried this also but same error occurs.

18.3.2+Branch.master.Sha.0ee1a557250c8000e864a91dcaeebdc1a4bbeb00

Source: Execute Query

Message: Object reference not set to an instance of an object.

Exception Type: System.NullReferenceException

An ExceptionDetail, likely created by IncludeExceptionDetailInFaults=true, whose value is:
System.NullReferenceException: Object reference not set to an instance of an object.
at UiPath.Database.Activities.ExecuteQuery.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)

Please help me in this ,Its urgent.

Thanks,
Supriya

Hi,
were you able to resolve the issue. If so please guide as i am getting the same problem.