close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()