robsuttonjr
MIS
I would like to know how to copy data from a view to a .XLS file. Also I would like to automate the process.
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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
COPY VIEW TO .XLS and SCHEDULE IT
- Thread starter robsuttonjr
- Start date
- Status
tlbroadbent
MIS
Create a DTS package that uses the view as the source and and Excel spreadsheet as the destination. Schedule the pacakge to run in a SQL Agent job. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
- Status
Similar threads
