Loading data from 3 different worksheets in Excel into one table

[Anonymous]

I have a workbook that has 3 different sheets where information in each sheet  (column headers) are the same, but the data is different.  I want to load all three into the same table.  How do I do this without joining on all the fields.

[awhitfield]

Hi Todd,

can you upload your xls?

Andy

[Anonymous]

attached

[maxgro · Accepted solution]

table:

LOAD *

FROM

[Multiple worksheet.xlsx]

(ooxml, embedded labels, table is [2015 EFD]);

concatenate (table)

load *

FROM

[Multiple worksheet.xlsx]

(ooxml, embedded labels, table is Active);

concatenate (table)

load *

FROM

[Multiple worksheet.xlsx]

(ooxml, embedded labels, table is [EFD History]);