Post reply

automate insert upate excel file format issue

  • October 11, 2011 at 8:28 am

    #260261

    hi,

    i have to insert and update some values which is daily coming from excel file but as everyday excel file format is different so tell me other possible ways to automate insert update ?

    i was doing it using SSIS but as everyday file format differs please tell me other possible ways

  • October 11, 2011 at 8:43 am

    #1392906

    Are the column headers of the file for the columns that you need consistent? I must ask though, why is the file format changing. Can you ask for this to remain constant?

    Thanks,

    Jared

    Jared
    CE - Microsoft

  • October 12, 2011 at 12:35 am

    #1393241

    file format means.. it is a excel file everyday but data is changing its position everyday..

    so how can i find out the proper data from that file...

    is there any thing i need to do with header ?

  • October 12, 2011 at 7:34 am

    #1393424

    What I am asking is if the columns from that file that you need (assuming that you only need a subset) change names every time. If the names of the columns are the same, you can import the file every night to a temporary table (not a temp table, but one that you will delete later) and then select from that table into your production table. If the column headers' names change, and the positions change, I am afraid that you have an issue. Why is the file changing? There should be standardization on something like this; i.e. if it is a file populated by people you create a template excel file and lock it from changes.

    Thanks,

    Jared

    Jared
    CE - Microsoft

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

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