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: 131
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