title: Bulk insert to SQL Server from Excel / CSV
body: <p>I need to bulk insert to SQL Server data from an Excel or CSV file. The data is close to 100k lines. I am using C#/.NET. In the Microsoft documentation I find this:</p>
  <pre><code>BULK INSERT Sales.Invoices
  FROM '\\share\invoices\inv-2016-07-25.csv'
  WITH (FORMAT = 'CSV'
    , FIRSTROW=2
    , FIELDQUOTE = '\'
    , FIELDTERMINATOR = ';'
    , ROWTERMINATOR = '0x0a');
  </code></pre>
  <p><a href="https://docs.microsoft.com/en-us/sql/t-sql/statements/bulk-insert-transact-sql?view=sql-server-ver15" rel="nofollow noreferrer">BULK INSERT (Transact-SQL)</a></p>
  <p>If I have an Excel file I can convert it to CSV and use this. This works great and it is very efficient, but my problem is that I do not have access to the file system on the SQL server. Has anyone an idea what is the best way to work around that or is there maybe a totally different approach that is better?</p>