<div>
Not sure but see if you are asking for this - <a href="https://www.codeproject.com/Articles/839901/Excel-and-VBA-Query-ListObject-Directly" rel="ugc">https://www.codeproject.com/Articles/839901/Excel-and-VBA-Query-ListObject-Directly</a>&nbsp;&lt;nopt&gt;
</div>


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

<div>
Pawan, no. That technique is not SQL. It's VBA manipulating the object directly.<br />
Norie, I have since learned that it is NOT possible to run SQL against a ListObject.<br />
<br />
I shall close the question.
</div>


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.

<div>
<div class="content wysiwyg-content">
Is it possible to use a ListObject in Excel as a Table to run SQL queries against?<br />
<br />
I mean normal SQL such as, SELECT, INSERT, UPDATE, DELETE statements.<br />
<br />
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?<br />
<br />
If yes, then please can you direct me to any resources?<br />
<br />
(I have Googled and drawn a blank. I'm wondering if the above can't be done. If so, why?)<br />
<br />
Thanks
</div>
</div>


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

Excel ListObejct - working with SQL

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.