03 Juli 2012 17:02
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?
04 Juli 2012 9:24Moderator
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.
- Ditandai sebagai Jawaban oleh Arwind - MSFTModerator 09 Juli 2012 8:05