Jump to content

Combine multiple CSVs


Recommended Posts

Hey, been a while since I have been around.

I have about 750 CSV files that I need to combine into 1. I am willing to use anything to combine them, be it SQL, Access, Excel, whatever...

The problem I am running into is this... They are not all the same. Some of them are identical, but others are not. They all do however contain a few key columns (4 specificly) that I need. The first row names the column, and then all other rows are the entries. Any idea on how I can handle this? Here is an example of what I am looking at:

Name ID Value1 Value2 Value3 Value4 Value5 Value6 Value7

Name ID Value1 Value3 Value4 Value6 Value7

Name ID Value1 Value2 Value3 Value5 Value6 Value7

Name ID Value2 Value3 Value4 Value5 Value7

So like, some of the files will have value2/4/5/6, but they ALL have Name, ID, Val1/3/7.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    • No registered users viewing this page.

  • Create New...