SQL Union in MS Excel 2007

A

aireq

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?
 
D

Daniel.C

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge Excel file into Word Document 3
Update several ppt documents from a single excel file 0
Merging from an Excel file with graphics 1
Found few bugs in my daily routine of work in excel for MAC 0
Shortcuts in OneDrive 0
Found few bugs in my daily routine of work in excel for MAC 0
Integrating information from Word to Excel (not mail merge) 1
MS Project Import Error Row 1 Column 5 2

Top