February 9, 2012 at 12:46 pm
Hi All,
I am trying to import data from sql server database into excel (Version Microsoft office 2003)file.
How i Need to load is,
In the 1st cell of the excel file I need to display the static name along with currentdate. after that i need to skip 4 rows and from 5th row on wards i need to insert data.
Below is the sampel formate.
Plz kindly help me in this regard.
Name - 02/08/2012
Location Touch_When Touch_By Created_By
1770 Japan22:03.1 b1263fd9_mcampos1b1263fd9_samuel
1770UK 22:03.1 b1263fd9_mcampos1b1263fd9_jim
Thanks,
Venkat
February 10, 2012 at 1:29 am
I would create 2 named ranges:
one for row 1 and the first 2 columns, to store the name and date.
one for the data starting at row 5.
You can write to a named range like a normal table.
Excel Destination (check the Important section)
Write the name and the data first and in a seperate dataflow the data.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 10, 2012 at 2:41 am
If you don't mind can you explain little bit clearly.
February 10, 2012 at 2:46 am
padmanabhuni.k (2/10/2012)
If you don't mind can you explain little bit clearly.
It was pretty clear, to be honest.
Which bit don't you understand?
February 10, 2012 at 2:56 am
Hi thanx for your reply.
In SSIS I dont know how to create named ranges to load data into excel.
February 10, 2012 at 3:10 am
You create the named ranges in Excel, not in SSIS - they are part of the spreadsheet.
February 10, 2012 at 3:18 am
padmanabhuni.k (2/10/2012)
Hi thanx for your reply.In SSIS I dont know how to create named ranges to load data into excel.
Excel Names -- Excel Named Ranges
It is the first Google result for excel named ranges
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy