pivot table - multiple excel sources
 

Hi

I'd like to join data from several excel sheets, ideally from different
workbooks

The SQL UNION ALL statement works OK to combine data for sheets from a
single workbook but is there a way to combine data from different workbooks
into a single
recordset and then associate a pivot table with this single recordset ?

thanks