How to export whole SQL database to MS Excel Workbook

Subject: How to export whole SQL database to MS Excel Workbook
From: "Ronald Schwarz" <RSchwarz -at- cosmocom -dot- com>
To: <techwr-l -at- lists -dot- techwr-l -dot- com>
Date: Fri, 28 Dec 2007 12:48:49 -0500

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: <>


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.

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

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

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 for more resources and info.


Previous by Author: Re: Creative writers among us?
Next by Author: Re: RoboHelp 7 query re: numbering
Previous by Thread: Re: Job function question
Next by Thread: Re: How to export whole SQL database to MS Excel Workbook

What this post helpful? Share it with friends and colleagues:

Sponsored Ads