Excel ListObejct - working with SQL

hindersaliva
hindersaliva used Ask the Experts™
on
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?)

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Analyst Assistant
Commented:
As far as I know this isn't possible, not even sure you can refer to the named range associated with a listobject but I'll need to check that.
Pawan KumarDatabase Expert
Awarded 2016
Top Expert 2016

Commented:
Not sure but see if you are asking for this - https://www.codeproject.com/Articles/839901/Excel-and-VBA-Query-ListObject-Directly <nopt>

Author

Commented:
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.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial