How to export whole SQL database to MS Excel Workbook

["Ronald Schwarz" <RSchwarz -at- cosmocom -dot- com>]

I have to document how 50% of the SQL tables in an application relate to
the user interface configuration menus so that the user can trace
through a configuration audit trail.
 
Can someone explain how to export the entire SQL database to a MS Excel
Workbook? I can only export one table at a time to a spreadsheet in
order to capture the column headings of the tables. For a few tables, I
also need the records in order to view the values of various settings in
the application.
 
The MS SQL Server Management Studio online help does not have an answer
and I cannot write SQL or VBS scripts to automate the process.
 
Ronald Schwarz

Senior Technical Writer 

CosmoCom, Inc.
121 Broad Hollow Road
Melville, NY 11747 USA
Phone:   +1 (631) 940-4320
Fax:     +1 (631) 930-3252
EMAIL:   RSchwarz -at- cosmocom -dot- com <mailto:chwarz -at- cosmocom -dot- com> 
URL:      http://www.cosmocom.com <http://www.cosmocom.com/> 

 
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Create HTML or Microsoft Word content and convert to Help file formats or 
printed documentation. Features include support for Windows Vista & 2007 
Microsoft Office, team authoring, plus more.
http://www.DocToHelp.com/TechwrlList

True single source, conditional content, PDF export, modular help.
Help & Manual is the most powerful authoring tool for technical
documentation. Boost your productivity! http://www.helpandmanual.com

---
You are currently subscribed to TECHWR-L as archive -at- web -dot- techwr-l -dot- com -dot- 

To unsubscribe send a blank email to 
techwr-l-unsubscribe -at- lists -dot- techwr-l -dot- com
or visit http://lists.techwr-l.com/mailman/options/techwr-l/archive%40web.techwr-l.com


To subscribe, send a blank email to techwr-l-join -at- lists -dot- techwr-l -dot- com

Send administrative questions to admin -at- techwr-l -dot- com -dot-  Visit
http://www.techwr-l.com/ for more resources and info.