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?)