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))
How do I construct a connection string to open a CloudBlob excel file?
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
Microsoft One Code Framework