title: BULK INSERT data from local file to remote sql server
body: <p>I want to upload some data from a local file on my pc via SQL-manager to a sql-database on azure.</p>
  
  <p>I tried</p>
  
  <pre><code>BULK INSERT gifts
     FROM 'c:\temp\trouwpartij.txt'  
     WITH   
        (  
           FIELDTERMINATOR =' |',  
           ROWTERMINATOR =' |\n'  
        );  
  </code></pre>
  
  <p>But unfortunatly the path is pointing to a location on the sql-server, which I cannot access.</p>
  
  <p>Any suggestions how to complete this simple task whitout actually developing a small application ?</p>