Aug 30, 2007 #1 dvimm Programmer Apr 26, 2007 23 US Hello, Is there anyway to specify starting row while we are exporting to excel thru DTS? Thanks
Aug 30, 2007 #2 AlexCuse Programmer Apr 13, 2006 5,416 US If you are exporting to an existing excel file, then it automatically starts in the first empty row. If you are creating one from scratch, I'm not sure how you can do this in a data pump task though. There is a lot you can do in vbScript. It's a little more work but you can create custom spreadsheets that way. Hope this helps, Alex [small]----signature below----[/small] I don't do any programming whatsoever Ignorance of certain subjects is a great part of wisdom Upvote 0 Downvote
If you are exporting to an existing excel file, then it automatically starts in the first empty row. If you are creating one from scratch, I'm not sure how you can do this in a data pump task though. There is a lot you can do in vbScript. It's a little more work but you can create custom spreadsheets that way. Hope this helps, Alex [small]----signature below----[/small] I don't do any programming whatsoever Ignorance of certain subjects is a great part of wisdom
Aug 30, 2007 Thread starter #3 dvimm Programmer Apr 26, 2007 23 US Thanks Alex ...I will look into it... Upvote 0 Downvote