Post reply

Load few tabs from excel

  • September 7, 2016 at 10:11 am

    #329943

    Hello all,

    Hope all are doing good! 🙂

    I am having a excel sheet which will contains around 20-24 tabs. Among those tabs i need to load data whose tab names are like below

    4QTR16,3QTR16,2QTR16,1QTR16,4QTR15,3QTR15,2QTR15,1QTR15

    Meaning of tab: example - 4QTR= fourth Quarter and 16 = year 2016.

    There are other tabs as well with different names. But i am facing the issue to fetch the data from above tab only. Also while loading i have to load column and year by configuring as below:

    For 4QTR16 i need to populate column as 4QTR= 4 and 16 = 2016 into table. These columns are not mentioned in the sheet. So i have to determine by using the tab name only.

    Thank you so much.

    Abhas.

  • September 7, 2016 at 10:20 am

    #1899618

    abhas (9/7/2016)

    Hello all,

    Hope all are doing good! 🙂

    I am having a excel sheet which will contains around 20-24 tabs. Among those tabs i need to load data whose tab names are like below

    4QTR16,3QTR16,2QTR16,1QTR16,4QTR15,3QTR15,2QTR15,1QTR15

    Meaning of tab: example - 4QTR= fourth Quarter and 16 = year 2016.

    There are other tabs as well with different names. But i am facing the issue to fetch the data from above tab only. Also while loading i have to load column and year by configuring as below:

    For 4QTR16 i need to populate column as 4QTR= 4 and 16 = 2016 into table. These columns are not mentioned in the sheet. So i have to determine by using the tab name only.

    Thank you so much.

    Abhas.

    OK, I understand. But what is your question, exactly?

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • September 8, 2016 at 12:23 am

    #1899696

    Hi Philip,

    I am able to load all tabs but how to load the tabs whose name format is : 1Q17, 4Q16,3Q16 etc.

    Thanks,

    Abhas.

  • September 8, 2016 at 6:06 am

    #1899762

    abhas (9/8/2016)

    Hi Philip,

    I am able to load all tabs but how to load the tabs whose name format is : 1Q17, 4Q16,3Q16 etc.

    Thanks,

    Abhas.

    To import data from one or more named sheets, create a connection manager as usual.

    Create a string package variable - 'SheetName' or whatever.

    Put the name of the sheet into the variable (this can be done in a loop, of course, for multiple sheets).

    Create a data flow and add an Excel source. Define the connection manager and set Data Access Mode to 'Table name or view name variable'.

    In variable name, enter your SheetName variable.

    Now you can iterate around the worksheets you are interested in.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

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

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