SQL query to select a range
- by hansika attanayake
I need to write an sql query (in c#) to select excel sheet data in "C" column starting from C19. But i cant specify the ending cell number because more data are getting added to the column. Hence i need to know how to specify the end of the column. Please help. I have mentioned the query that im using. I need to know what should be entered at the position of "C73"?
OleDbCommand ccmd = new OleDbCommand(@"Select * From [SPAT$C19:C73]", conn);