View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
campwes campwes is offline
external usenet poster
 
Posts: 3
Default Help request for vb .net in excel

kh,

You can use an OleDbDataReader (ADO.NET) and query the cells in your range:

Dim cmd As OleDbCommand = dbConn.CreateCommand()
cmd.CommandText = " select * from [Sheet1$A2:A10] "
rdr = cmd.ExecuteReader()

Use Console.WriteLine() or whatever to output the data where you need.

Ciao,