The requirements for my application are searching for the excel file, downloading the file, reading each line from the excel file, and pasting it into the database.
I am building this application on Windows Azure. Prior to this, I have successfully used OleDbDataAdapterto read data from an excel file into dataset.
Used connection strings:
FOR XLS file:
connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strNewPath & ";Extended Properties=""Excel 8.0;HDR=Yes;IMEX=2"""
FOR XLSX file:
connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & strNewPath & ";Extended Properties=""Excel 12.0;HDR=Yes;IMEX=2"""
They will use the following service providers Microsoft.Jet.OLEDB.4.0and Microsoft.ACE.OLEDB.12.0in Windows Azure? Working with Cloud also works, and is this the best way to access Excel files in C #?
Any new ideas and suggestions are welcome.
source
share