ExcelBanter - SQL Union in MS Excel 2007

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - SQL Union in MS Excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/234443-sql-union-ms-excel-2007-a.html)

aireq

SQL Union in MS Excel 2007

I have a number of CSV files of data that I want to Union together into a
single table in MS Excel. All the CSV files have the same names and number of
columns.

In a relational database like Access or SQL I could use a Union Query, but
this has to be in Excel. How can I quickly merge all of these files into one
in Excel?

Daniel.C[_3_]

SQL Union in MS Excel 2007

Shane Devenshire posted a solution for an Excel multi sheet workbook.
You may adapt it for several CSV files.
HTH
Daniel

I have a number of CSV files of data that I want to Union together into a
single table in MS Excel. All the CSV files have the same names and number of
columns.

In a relational database like Access or SQL I could use a Union Query, but
this has to be in Excel. How can I quickly merge all of these files into one
in Excel?

All times are GMT +1. The time now is 07:05 PM.