Earlier, I posted about using ADO to query a select number of columns from a spreadsheet. It used the CopyFromRecordset method to get the data in the spreadsheet. In this example, I change the CommandText (SQL) property of an existing QueryTable to show the data.
First, I used Data - Get External Data - [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2010/04/28/dynamic-columns-in-ms-query-ii/
Posted
Apr 28 2010, 07:30 AM
by
Daily Dose of Excel