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.
| Author |
Topic |
|
PaulTeal
Yak Posting Veteran
67 Posts |
 Posted - 2004-07-21 : 10:30:33
|
| I am exporting some data from a SQL Server Database to Excel 2000 using DTS and am hitting a snag. I want to export to a specific cell location in the spreadsheet (e.g. cells below and to the right of A7) but I do not see an option for anything like that.Paul Tealpaul@partytilyoupop.com |
|
|
cas_o
Posting Yak Master
154 Posts |
Posted - 2004-07-21 : 10:38:25
|
| Can we have bit more background, why do you need the data to start at A7 ?I'm not certain this is possible when exporting from SQL, however if you were importing from SQL (ie controlling things from the Excel End with get external data from the data menu in Excel) you can decide where you want it to go.;-]... Quack Waddle |
 |
|
|
PaulTeal
Yak Posting Veteran
67 Posts |
Posted - 2004-07-21 : 12:37:42
|
| I am automating a manual process that updates an existing spreadsheet. The excel spreadsheet has header info in the first 6 rows, so I want to begin my export at row 7 so that I will not overwrite the headers.Any ideas?Paul Tealpaul@partytilyoupop.com |
|
|
|
tobyh
Starting Member
1 Post |
Posted - 2004-07-21 : 21:16:25
|
| Any help on this would be much appreciated!I have an Excel sheet which has a 19 line pre-defined header and then 9 columns of data that must be filled out from a table.Toby |
|
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-07-21 : 23:48:42
|
| Paul, My suggestion would be to use a DTS ActiveX script task. You can then reference the Excel object model directly and have complete control over the content and format of the spreadsheet. I would have a DTS package with a single ActiveX task that:-creates the recordset containing the data you need-opens the Excel spreadsheet (using Excel's object model)-populate the individual cells as requiredetcetcTim |
|
|
|
|
|
|
Excel Export to Specific Cells