title: BULK INSERT error code 3: The system cannot find the path specified
body: <p>I am trying to bulk insert a local file into a remote MS_SQL database using pyodbc. I am able to connect to the DB and I am able to <code>INSERT INTO</code> tables, as I have done it before. Where I have been having issues is to <code>BULK INSERT</code>.</p>
  
  <p>I am using <code>BULK INSERT</code> as a way to speed up my <code>INSERT</code> process. </p>
  
  <p>The code looks like this:</p>
  
  <pre class="lang-python prettyprint-override"><code>statement = """ BULK INSERT BulkTable FROM 'C:\\Users\\userName\\Desktop\\Folder\\Book1.csv' WITH (
         FIRSTROW=2,
         FIELDTERMINATOR=',',
         ROWTERMINATOR = '\\n'
  );
  """
  cursor.execute(statement)
  cnxn.commit()
  </code></pre>
  
  <p>This code yields this error:</p>
  
  <pre class="lang-none prettyprint-override"><code>Traceback (most recent call last):
     File "tester.py", line 41, in &lt;module&gt; cursor.execute(statement)
     pyodbc.ProgrammingError: 
      ('42000', '[42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]  Cannot bulk load because the file    "C:\\Users\\userName\\Desktop
  \\Folder\\Book1.csv" could not be opened.
      Operating system error code 3(The system cannot find the path specified.). (4861) (SQLExecDirectW)')`
  </code></pre>
  
  <p>I really don't understand why it can't open the file as the path is definitely correct. </p>
  
  <p>Let me know if you need any more information.</p>