SAP BODS

[#1]

Hi

Anyone can help on below

I am going to use excel files as source and moving the data to MSSQL DB using BODS

Have 12 sheets per excel for 12 months.how to get 12 months data into one table?? Please anyone help me???

[Former Member · Accepted solution]

Hi Priya,

You can use two ways to to do this( with assumption that structure of all the excel file/sheet is same).

1- create 12 excel file format connection and merge it in to one table.

2- create one file format , one global variable to indicate "NUMBER" option , put this file format using dataflow inside "while" loop and then link this file to table( inside the table uncheck the option of drop and delete table option.).

Please try and update the thread

Cheers,

Shiva Sahu