SQL query to select a range

Posted by hansika attanayake on Stack Overflow See other posts from Stack Overflow or by hansika attanayake
Published on 2012-10-17T04:42:56Z Indexed on 2012/10/17 5:01 UTC
Read the original article Hit count: 133

Filed under:
|

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);

© Stack Overflow or respective owner

Related posts about c#

Related posts about excel