Scenario:
Open URL - https://www.nseindia.com/market-data/live-equity-market?
Extract the whole table data into Excel (xslx)
Code Snapshot:
Connection String:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source="C:\RPA\Test\ExtractedDetails.xlsx";Extended Properties="Excel 12.0 Xml;HDR=YES";
SQL Query:
INSERT into [Sheet2$$] values ('$StockTableRow[0]$','$StockTableRow[1]$','$StockTableRow[2]$','$StockTableRow[3]$','$StockTableRow[4]$','$StockTableRow[5]$','$StockTableRow[6]$','$StockTableRow[7]$','$StockTableRow[8]$','$StockTableRow[9]$','$StockTableRow[10]$','$StockTableRow[11]$','$StockTableRow[12]$')


Error:

how to proceed further