Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Starting row -export to excel

Status
Not open for further replies.

dvimm

Programmer
Apr 26, 2007
23
US
Hello,
Is there anyway to specify starting row while we are exporting to excel thru DTS?
Thanks
 
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
 
Thanks Alex ...I will look into it...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top