how to export tables from sql 2008 into multiple excel files

• muraleeswaran.k

  Newbie

  Points: 9

  More actions

  November 19, 2009 at 11:08 pm

  #71885

  hey frndz...

  how to export tables from sql 2008 into multiple excel files(not in multiple pages in same file) i try alot but its put the tables in same excel file in separate pages.. how to rectify these???:-)

• Bru Medishetty

  SSC-Insane

  Points: 23606

  More actions

  November 20, 2009 at 12:27 am

  #1081995

  Can you explain how are you doing it currently?

  I guess you must be using SSIS, if so, have you used multicast transformation???

  ---

  Bru Medishetty

  Blog -- LearnSQLWithBru

  Join on Facebook Page Facebook.comLearnSQLWithBru

  Twitter -- BruMedishetty