Query on Excel with Ado.Net
Feb 5th, 2007 by Onyrix 589 Views | 
Email This Post
| 
Print This Post
(3 votes, average: 5 out of 5)
Loading ...
Suppose you have an Excel binary file (or in another ms format) and suppose you have to extract some data from it programmatically…
Suppose you don’t want to send commands to the installed Office Excel with OLE automation or similar technologies.
Suppose you want to query that file as a relational DB.
Well, here is the solution…
You can interface your code with the Excel file with ADO.NET, here is the example:
Code:
Dim cnn As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Test.xls;Extended Properties=""Excel 8.0;HDR=YES;""")
Dim da As New OleDb.OleDbDataAdapter(”Select * from [Sheet1$]”, cnn)
Dim ds As New DataSet(”TestExcel”)
da.Fill(ds)
Simply not?
del.icio.us
Digg
Furl
Reddit
Technorati
Stumbleupon