exporting data to different named ranges in excel

• Bakr Ben Ayad

  Old Hand

  Points: 325

  More actions

  February 14, 2008 at 6:01 pm

  #69790

  Hi

  I'm trying to pull chunks of data from the database and export each one of them to a separate named range in an excel spreadsheet. I have the excel spread sheet formatted so I just need to export the data to it

  here are the steps that I follow:

  I created a named range in excel

  I created the excel connection to the excel file

  I created the connection that pulls data from the database

  I created the transform data task that exports data from the database to Excel

  then I created a SQL Task in DTS package to drop and create the table of the named range (in order to clean the data that exists already in the spreadsheet)

  but this latter doesn't work properly because I create three fields as decimal and when I look in the Data Transform Task, I find that it creates a table with three fields but the first one as short not as decimal.

  what could be causing this?

  if this doesn't sound right, what is the best way to export data to many different named ranges in excel.

  please help

  Thank you in advance for your help

• Michael-321617

  SSC Rookie

  Points: 33

  More actions

  March 15, 2008 at 11:56 pm

  #790112

  why don't you tried converting the select output variable to whatever you like in your select statement. Hope this work for you. Thanks.