title: LOAD DATA INFILE in visual studio using SQL server ERROR: "The LOAD DATA SQL construct or statement is not supported"
body: <p>I have following problem: I have a <code>.csv</code> file with data (around 30mb). I like to load content of that file to my database more specific to my IPBlock table which look like this:</p>
  
  <pre><code>startIP: Int
  endIP: Int
  LocationID: Int
  </code></pre>
  
  <p>and content of a file looks like that:</p>
  
  <pre><code>   "16777216","16777471","17"
     "16777472","16778239","49"
     "16778240","16778495","14409"
  </code></pre>
  
  <p>I try to execute this query:</p>
  
  <pre><code>LOAD DATA LOCAL INFILE 'C:\Users\Molu\Desktop\GeoLiteCity_20131203\test.csv'
  INTO TABLE IPBlock 
  FIELDS TERMINATED BY ',' 
  ENCLOSED BY '"' 
  LINES TERMINATED BY '\n' 
  (startIP , endIP, LocationID); 
  </code></pre>
  
  <p>and I got following errors </p>
  
  <blockquote>
    <p>The LOAD DATA SQL construct or statement is not supported.</p>
  </blockquote>
  
  <p>and </p>
  
  <blockquote>
    <p>Error Source:".Net sqlClient Data Provider" Error message "Incorrect syntax near LOCAL"</p>
  </blockquote>
  
  <p>I already try version with double"\" like: <code>C:\\Users\\Molu</code> and with and without "LOCAL" key-word (here only difference is that error message is: "Incorrect syntax near INFILE" )</p>
  
  <p>Do you have any ideas ?  Thanks in advance.</p>