Good morning all,
I created a view that selects the rows of the records from a table that matches where condition.
I need to export the records to excel so I could send it out...
what is the best way to do?
Please tell me detail, I don't know much about SQL 2000, still learning.
Thank you,
YanorooUse the DTS wizard (import and export data in start menu->Microsoft SQL server).
The wizard will ask you the information needed in order to complete the operation. Select the MS-Excel driver as a destination (as well as the output filename), choose the first options (export tables an views) and select your view in particular.
Shouldn't be too hard.|||yes, I was able to do that!
Thank you!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment