how to change update excel file sheet name by using SQL Query

• rajarao.m

  SSC Veteran

  Points: 241

  More actions

  March 18, 2013 at 5:05 am

  #290993

  Dear all,

  Hope good all are

  i have a small requirement..

  actually i have excel file dail i am opening the file and executing one query and copying output of that resultant query...

  now i done auto file creation along with data without opening file and copying by sql script, but in that sheet having some followed with date like below

  DlyColl_PJAMH_20130301_20130317

  i want to update that name followed by yesterday date