Urgent.....SSIS Task of converting Excel to Sql Server tables

• elegantkvc

  SSCommitted

  Points: 1910

  More actions

  May 21, 2008 at 1:27 am

  #207568

  hi,

  I had an excel contains two sheets which have the data of timesheet of a company.

  I had successfully transferred the excel into sql tables by creating SSIS Package using SSIS Import or Export wizard.

  The problem is daily we are getting Excel sheets i want to get the

  data to be added to those existing tables.But now i have to delete the existing tables and append the daily sheet to the existing excel sheet and export....How to get this done...Help me out friends.....

• Ben Sullins-437405

  SSCertifiable

  Points: 5397

  More actions

  May 21, 2008 at 8:52 am

  #818619

  Is the challenge that:

  1. There are there multiple sheets that need to be consolidated?

  2. The sheets are in different formats (eg. columns in different order)?

  ---

  Cheers,

  Ben Sullins
  bensullins.com
  Beer is my primary key...

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736212

  More actions

  May 21, 2008 at 10:31 am

  #818718

  Duplicate: discussed here: http://www.sqlservercentral.com/Forums/Topic504243-148-1.aspx