question

khaja232 avatar image
khaja232 asked

how to load multiple tables data into different sheets of excel file

I have three tables data with different structure these tables lodes into the three different excel sheets into a single excel file.
database-files
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Can you provide more info? I believe from your question you have 3 tables with differing schemas loading into 3 excel worksheets and you want them to load into one. Are they in the same workbook? Where is this data loading from? Do you have examples? The more info you provide the more likely you will be to get a solid answer.
0 Likes 0 ·

1 Answer

·
nidheesh.r.pillai avatar image
nidheesh.r.pillai answered
You can do it using SSIS via Data Flow Task. Look up the Internet for examples if you are new to SSIS and reach us if you get stuck.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.