I have about 20 .csv files which are around 100-200mb each. 

They each have about 100 columns. 

90% of the columns of each file are the same; however, some files have more columns and some files have less columns.

I need to import all of these files into one table in a sql server 2008 database.

If the field does not exist, I need it to be created.

**question**: What should be the process with this import? How do I more efficiently and quickly import all of these files into one table in a database, and make sure that if a field does not exist, then it is created? Please also keep in mind that the same field **might** be in a different location. For example, CAR can be in field **AB** in one csv whereas the same field name (CAR) can be **AC** in the other csv file. The solution can be SQL or C# or both.