Combine multiple CSVs

[DysfunktinaL]

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:

File1
Name	ID	Value1	Value2	Value3	Value4	Value5	Value6	Value7

File2
Name	ID	Value1	Value3	Value4	Value6	Value7

Flie3
Name	ID	Value1	Value2	Value3	Value5	Value6	Value7

File4
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.

[IcemanND]

First, is the example minus actual data what you really have? Because that is tab delimited not comma delimited. and how do you know if values 2/4/5/6 were not in the file?