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 |
|
Krb_iiaba
Starting Member
16 Posts |
 Posted - 2006-02-28 : 12:08:04
|
| I am looking for the most efficient way to populate an excel spreadsheet with a recordset that is returned from a stored procedure.Only options I get on Excel side for 'Import External Data' is to retrieve data from either Tables or Views. I am sure there is a way to handle sprocs.Any ideas appreciated.Thanks |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-02-28 : 12:14:56
|
| You can use DTS..Create a connection to SQL Server, create a connection to your excel file and use a data pump task.. |
 |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-02-28 : 14:03:46
|
| Krb_iiaba,If I understood ur requirement correct, u want to write the content of a recordset (Coming as a return of a Stroed Procedure) to an Excel File?Where do you want to do it. In front end or back end ?What front end are you using ? VB / ASP ? or anything else?Do u have the rights to create or change stored procedures or create a DTS in the DB? |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Populate Excel with SP