Query to access excel data....

[AnnnS]

hi all i am using odbc connection to query the data from excel ... i am able to ... the query i use is select empid from [sheet1$]... (empid is the column header in the first row) the problem is i want to access the data by ponting the index of the column .. something like select column1 from [sheet1$] can anyone suggest the query for that ??? Annns

[sam]

SELECT * FROM [Sheet1$A1:A1000]

[AnnnS]

thanx for the reply :).. hope it will help me... but still one more doubt:confused:... then how will we get the value from result set?? like rs.getString("?"); ??? Thnks Annns

[sam]

use adapter to fill data .and use them like myDataTable.Rows[row_num][column_no]

[AnnnS]

thanx so much .. let me try it out !!