How to insert values to a data table based on unique other coloum

[Palaniyappan (Forum Leader)]

@Tharusha_Fernando

UPDATE datatable
SET Status= 'Pass"
WHERE CustomerID = 122

Hi

Check this thread for how to use excel as a database and pass Sql query to update the rows

How to use Excel as datasource and execute SQL Query?

Hi Team, I am trying to connect Excel as datasource, but not able to connect. I did some research and found following post. But still it is not helpful getting same error as mentioned. I have attached the excel file. I am looking for correct connection string for xlsx or xls and SQL query. Source.xlsx (8.6 KB) Kindly assist.

Cheers @Tharusha_Fernando