OleDBConnection with CloudBlob

Question

Hi,

I have moved a web app to azure and am having trouble with connecting to excel files that are uploaded.

Since they are stored as CloudBlobs I do not know how to connect to one of these with an OleDBConnection:

 string strConn = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + containerName+'/'+filename + ";Extended Properties='Excel 12.0;HDR=YES;'";
            DataSet output = new DataSet();

            using (OleDbConnection conn = new OleDbConnection(strConn))
            {
                conn.Open();

How do I construct a connection string to open a CloudBlob excel file?

Thanks,

  John.

Answer 1

Hi,

As far as i know, you cant connect the Blob storage Excel files by OLeDbConnection directly, you can download the Excel files to local and then connect it.

Hope this helps.

---

Please mark the replies as answers if they help or unmark if not. If you have any feedback about my replies, please contact [e-mail] Microsoft One Code Framework