Hello guys,
I will be really Thankful if someone would help me with this..
Im trying to read from an Excel file..
This is the code I am trying
VB Code:
Dim conn As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Test.xls;Extended Properties=""Excel 8.0;HDR=YES;""") Dim excelcmd As New OleDb.OleDbCommand("Select * from Field Level analysis")
What I basically need help with is...What do you consider as a table in an excel sheet? How do we actually send a select query to an excel sheet...For example,I would like to retrieve all the records on the first sheet..How do I do that?
Thanks,
