title: How can I import this formated txt file into a SQL Server Table
body: <p>I have txt files that are a output of one especific Software, that file always have the same format, see it below. The datas starts at line 31, in this example i put only a feel lines of the TXT file, I can not change this format due to it is the output of one software. I need to import this file into a Table in SQL Server. How do I do it?</p>
  
  <pre><code> RECORDED_YEAR                  Col:     1 -     4 Decs:   0 Mult: 1.000000  
   RECORDED_DAY                   Col:     5 -     8 Decs:   0 Mult: 1.000000  
   RECORDED_HOUR                  Col:     9 -    10 Decs:   0 Mult: 1.000000  
   RECORDED_MINUTE                Col:    11 -    12 Decs:   0 Mult: 1.000000  
   RECORDED_SECOND                Col:    13 -    14 Decs:   0 Mult: 1.000000  
   SHOTLINE_NUMBER                Col:    18 -    21 Decs:   0 Mult: 1.000000  
   SHOT_POINT_NO                  Col:    22 -    25 Decs:   0 Mult: 1.000000  
   RECEIVERLINE_NUMBER            Col:    26 -    29 Decs:   0 Mult: 1.000000  
   FIELD_STATION_NUMBER           Col:    30 -    33 Decs:   0 Mult: 1.000000  
   XREC                           Col:    35 -    45 Decs:   2 Mult: 1.000000  
   YREC                           Col:    46 -    56 Decs:   2 Mult: 1.000000  
   ELEV_REC                       Col:    57 -    62 Decs:   2 Mult: 1.000000  
   XSHOT                          Col:    63 -    73 Decs:   2 Mult: 1.000000  
   YSHOT                          Col:    74 -    84 Decs:   2 Mult: 1.000000  
   ELEV_SHOT                      Col:    85 -    90 Decs:   2 Mult: 1.000000  
   TRCHDR3_TILTERROR              Col:    91 -    92 Decs:   0 Mult: 1.000000  
   TRCHDR3_RESISTERROR            Col:    93 -    94 Decs:   0 Mult: 1.000000  
   TRCHDR5_LEAKAGEERROR           Col:    95 -    96 Decs:   0 Mult: 1.000000  
   FIELD_RECORD_NO                Col:    97 -   102 Decs:   0 Mult: 1.000000  
   EXTHDR_SWATHID                 Col:   103 -   106 Decs:   0 Mult: 1.000000  
   DATA_RMSAMPLITUDE              Col:   109 -   119 Decs:   8 Mult: 10000.000000  
   VWUSER_1                       Col:   121 -   125 Decs:   0 Mult: 1.000000  
   CHANNEL_NO                     Col:   127 -   137 Decs:   0 Mult: 1.000000  
   VWUSER_7                       Col:   140 -   142 Decs:   0 Mult: 1.000000  
   VWUSER_8                       Col:   144 -   146 Decs:   1 Mult: 1.000000  
   DATA_MAXFREQ                   Col:   148 -   154 Decs:   3 Mult: 1.000000  
   DATA_MAXABSAMPLITUDE           Col:   156 -   166 Decs:   4 Mult: 10000.000000  
   VWUSER_22                      Col:   168 -   175 Decs:   3 Mult: 1.000000  
   VWUSER_11                      Col:   177 -   181 Decs:   0 Mult: 1.000000  
   VWUSER_12                      Col:   183 -   187 Decs:   0 Mult: 1.000000  
    18 327113458   5090115210965074     0.00       0.00   0.00      0.00       0.00   0.00   0 0 0    12   1  57.74633959     1           1    0 1.0 13.645  3703.4148   0.008        1     1 
    18 327113458   5090115210965075     0.00       0.00   0.00      0.00       0.00   0.00   0 0 0    12   1  35.32746807     1           2    0 1.0 18.519  3493.8994   0.008        1     1            
    18 327113458   5090115210965076     0.00       0.00   0.00      0.00       0.00   0.00   0 0 0    12   1  86.58912033     1           3    0 1.0 22.904  4077.5797   0.008        1     1            
    18 327113458   5090115210965077     0.00       0.00   0.00      0.00       0.00   0.00   0 0 0    12   1  53.32520232     1           4    0 1.0 23.392  5024.1262   0.008        1     1            
    18 327113458   5090115210965078     0.00       0.00   0.00      0.00       0.00   0.00   0 0 0    12   1  87.56771684     1           5    0 1.0 22.417  6922.9585   0.008        1     1    
  </code></pre>