Link to home
Start Free TrialLog in
Avatar of hindersaliva
hindersalivaFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Excel ListObejct - working with SQL

Is it possible to use a ListObject in Excel as a Table to run SQL queries against?

I mean normal SQL such as, SELECT, INSERT, UPDATE, DELETE statements.

I can run SQL statements on an Access database table via VBA and ADO. So my question is, is it possible to substitute an Excel ListObject in place of the Access Table?

If yes, then please can you direct me to any resources?

(I have Googled and drawn a blank. I'm wondering if the above can't be done. If so, why?)

Avatar of Norie

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of hindersaliva


Pawan, no. That technique is not SQL. It's VBA manipulating the object directly.
Norie, I have since learned that it is NOT possible to run SQL against a ListObject.

I shall close the question.