<div>
You can use PowerPivot.<br />
<br />
HTH,
</div>


<div>
Thanks but I am trying to find something specifically in VBA
</div>


<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I have several tables that are dumped onto Excel spreadsheets<br />
I know that creating a query by linking these tables would be <br />
easy in a database, but is this achievable in Excel? In other words<br />
can SQL be used within Excel?
</div>
</div>


Hi

I have several tables that are dumped onto Excel spreadsheets
I know that creating a query by linking these tables would be 
easy in a database, but is this achievable in Excel? In other words
can SQL be used within Excel?

Excel VBA  using SQL to join tables

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.