Excel file Reading

• ranganathanmca

  SSC Eights!

  Points: 920

  More actions

  March 1, 2011 at 10:38 pm

  #235400

  Hi guys.,

  I am facing some problem from Excel source file reading because i need to read sheet1$ from column B16 to column R16 data with end of excel document using below query

  Query : SELECT * FROM [sheet1$b16:R16]

  but it's displaying only one row please give me some suggestion.,one more suggestion also : i don't wanted to upload Last 3 row record of the excel document please suggest me to avoid those row query

  thanks for u r great help

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  March 3, 2011 at 1:47 pm

  #1294308

  Is this what you meant?

  SELECT B,

  C,

  D,

  E,

  F,

  G,

  H,

  I,

  J,

  K,

  L,

  M,

  N,

  O,

  P,

  Q,

  R

  FROM [sheet1$]

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato