How to bulk load CSV files into SQL Server Express?

I have 2,616 CSV files with each having an average of 3,200 records.  

I need to combine all of these records into a single large table in SQL Express so that I can do some research on the data and output some charts based on that research.

What is the easiest/fastest way to get all of that data into a single table in SQL Server Express?  (Some of the text fields have commas in them - if that matters.)
JimHubbardAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Norman MainaConnect With a Mentor Commented:
If the CSV files have the same format,in one folder and have teh columns required to match sql server columns ,you can use SQL Server Intergration Services to create a package to loop through the folder and upload the CSV data into your SQL server table.

This should get you started with SSIS:
http://msdn.microsoft.com/en-us/library/ms170419.aspx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.