title: How do I create a table in SQL from this text file?
body: <p>I'm trying to create a table in a database using SQL.  The data is currently in a text file that looks like <a href="http://i.imgur.com/rYUnY.png" rel="nofollow">this</a>, but has thousands of lines like that.</p>
  
  <p>My trouble lies primarily in the parameters of the "CREATE TABLE" function.  Is there a way to say that I want all of the columns?  Right now the code looks like:</p>
  
  <pre><code>CREATE TABLE dbo.CFTC_Fin_Data
  (
  
  )
  
  BULK INSERT dbo.CFTC_Fin_Data
      FROM 'H:\user\Desktop\CFTCData1.txt' 
      WITH 
      ( 
          FIELDTERMINATOR = ',', 
          ROWTERMINATOR = '\n' 
      );
  </code></pre>
  
  <p>Thanks for any help.  I'm pretty new to SQL, so I apologize if similar questions have been answered already, but I couldn't understand any of the answers that I read.</p>