title: how to bulkcopy Excel file from Azure Blob
body: <p>I have made an mvc application which saves excel file on azure blob blob storage. now i want to read the content of this excel file. </p>
  
  <p>earlier i saved this file on my c:/temp folder and code to bulk copy it is as follows :-</p>
  
  <pre><code>         string excelConnectionString = string.Format(@"Provider=Microsoft.ACE.OLEDB.12.0;Data      Source={0};Extended Properties=""Excel 12.0 Xml;HDR=YES;""", path);
  
          OleDbConnection connection = new OleDbConnection();
  
          connection.ConnectionString = excelConnectionString;
  
          OleDbCommand command = new OleDbCommand("select * from [Sheet1$]", connection);
  
          connection.Open();
  
          DbDataReader dr = command.ExecuteReader();
              using (var bulkCopy = new SqlBulkCopy(ConfigurationManager.ConnectionStrings["myString"].ConnectionString, SqlBulkCopyOptions.KeepNulls &amp; SqlBulkCopyOptions.KeepIdentity))
              {
                 //my logic
               }
            connection.Close();
  </code></pre>
  
  <p>since i want to implement this solution on Azure cloud. </p>
  
  <p>now i am saving excel file to Azure blobstorage instead of c:/temp.
  but i am not able to bulkcopy it. </p>
  
  <p>Please suggest something.</p>