Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Import sql to excel - Determine cells to populate

Author  Topic 

Bex
Aged Yak Warrior

580 Posts

Posted - 2006-04-03 : 10:54:52
I have created a DTS package that copies an excel template file, populates it using a view, and then renames the file. When importing the data into the spreadsheet, it appears to begin at about row 400 and something. Is there a way to determine which cell to start at?

Thanks in advance

Hearty head pats

Bex
Aged Yak Warrior

580 Posts

Posted - 2006-04-03 : 11:14:18
I remember seeing a post by Madhivanan about working with excel spreadsheets, but cannot find it.

Hearty head pats
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-04-03 : 19:35:18
Is it this ? http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926



KH

Choice is an illusion, created between those with power, and those without.
Go to Top of Page

Bex
Aged Yak Warrior

580 Posts

Posted - 2006-04-06 : 07:05:11
Brilliant. That is it! Thanks Khtan, you're a star!

Hearty head pats
Go to Top of Page
   

- Advertisement -