0

I am working on an excel add-in. I want to know if there is a way to fetch answer from the table in the excel sheet using an SQL query.

For example:

I have a table as below in the excel sheet:

Height Width

10 5

20 10

my SQL query is: select height from table where width = 5

So is there a way where I can run this query and it will give me the answer.

If not, then is there a way by which I can create a database from excel and run this query and fetch the result.

Nimz
  • 1
  • 2
  • 1
    You should usé ADODB like [that](https://stackoverflow.com/questions/27385245/using-excel-vba-to-run-sql-query) – DonKnacki Apr 02 '21 at 19:48
  • @DonKnacki I want to connect to the database using the excel add-in taskpane (React). Can I use ADODB in taskpane? sorry i am new to excel add-in. – Nimz Apr 04 '21 at 17:25

0 Answers0