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 |
|
kreplech
Starting Member
10 Posts |
 Posted - 2008-05-29 : 18:13:58
|
| Hello all,I'm looking to automate a process. We have a guy who copies data from a SQL 2000 view and pastes it into an existing, pre-formatted Excel worksheet.I'd like to automate this process, but I've never done this before. One caveat is that the data has to be pasted into specific cells (A9:M20) because of existing functions in the worksheet.I'm thinking .NET probably makes this kind of think pretty easy.Can somebody please point me in the right direction?Much appreciated!!!M |
|
|
osupratt
Posting Yak Master
238 Posts |
Posted - 2008-06-13 : 13:37:40
|
| I would personally recreate this Excel sheet in SSRS. You should have Reporting Services if you have SQL Server. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
SQL 2000 data dump to Excel 2003