In MS SQL Management Console I can right-click on any Table and I have
the option All Tasks > Export Data where I can export the table to
Excel. In a View however this isn't there. I have many views I want
to simply export to Excel, but the only way I've found to do it is
creating an ODBC connection to the MS SQL database from MS Access,
linking the Views to Access Tables, and exporting from Access. surely
there's someway to export a View to Excel within MS SQL easily like
exporting a table...
Thanks --
AlexIf this is a one-off task, the Import/Export Wizard can export to a
..xls. If you need to run it regularly, then you can save the DTS
package created by the wizard, and modify it as required.
Simon
No comments:
Post a Comment