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.
can you upload your xls?
(ooxml, embedded labels, table is [2015 EFD]);
(ooxml, embedded labels, table is Active);
(ooxml, embedded labels, table is [EFD History]);
Retrieving data ...