We help IT Professionals succeed at work.

Excel ListObejct - working with SQL

hindersaliva
hindersaliva asked
on
63 Views
Last Modified: 2018-02-02
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

Analyst Assistant
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
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.