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?)
Thanks
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
SQL
Last Comment
hindersaliva
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Not sure but see if you are asking for this - https://www.codeproject.com/Articles/839901/Excel-and-VBA-Query-ListObject-Directly <nopt>
ASKER
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.
Norie, I have since learned that it is NOT possible to run SQL against a ListObject.
I shall close the question.