title: Create a new table and import data from csv file into SQL Server 2005
body: <p>I have several files about 15k each of CSV data I need to import into SQL Server 2005.</p>
  
  <p>What would be the simplest way to import the csv data into sql server? Ideally, the tool or method would create the table as well, since there are about 180 fields in it, this would simplify things.</p>