title: Create a SQL Server table from text file
body: <p>I need to find a way to create a table from a text file that contains the field definitions (around 100 or more) of what my table structure should look like.  Here is a sample of fields names with size and description:</p>
  
  <pre>
  da_ctat   1 progress status of a sample
  vc_acct   6 Assigned account
  qc_bact   6 billing account #1
  lc_bac2   6 billing account #2 for a split
  ...
  ...
  zc_bar   12 z code
  pc_wav    1 wai
  oc_p1     1 ftp1
  tc_df1    1 ftp2
  kc_qq     1 ztp
  mc_split  1 split billing
  </pre>
  
  <p>Here is what the above text means</p>
  
  <pre>
  column 1-8 character is the field name
  column 9 space 
  column 10-11  is the size of field name
  column 12 space 
  column 13 - 80 is field comment
  </pre>
  
  <p>I need to create a stored procedure or find some other way that will create a table with the fields show above.  For example,
  a field name da_ctat that is 1 character long and description "progress status of a sample".  The next field in the table called vc_acct, 6 characters long and description of "Assigned account", etc...a</p>
  
  <p>Since I have over hundred fields to create, is there a way to write a stored procedure to create this table structure without me having to manually create the fields for a table? </p>
  
  <p>thanks for your assist community
  Nick</p>