Post reply

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

  • 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.....

  • 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...

  • May 21, 2008 at 10:31 am

    #818718

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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply