Re: How to export whole SQL database to MS Excel Workbook

Subject: Re: How to export whole SQL database to MS Excel Workbook
From: "Gene Kim-Eng" <techwr -at- genek -dot- com>
To: <techwr-l -at- lists -dot- techwr-l -dot- com>
Date: Fri, 28 Dec 2007 11:37:30 -0800

I don't have a lot of database experience, but for most of the
ones I have worked with, the "entire database" would be a
useless jumble of data unless it was sorted into reports, i.e.,
"tables." What you would need to do is generate a report
whose parameters are wide enough to include all the
database entries by selecting all possible sorting categories
and setting all the value ranges wide enough to include all
database entries. Then you would export that table to your
spreadsheet.

Gene Kim-Eng


----- Original Message -----
From: "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.

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

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.


References:
How to export whole SQL database to MS Excel Workbook: From: Ronald Schwarz
Re: How to export whole SQL database to MS Excel Workbook: From: Mike Starr

Previous by Author: Re: new laptop
Next by Author: Thoughts on an Editing Portfolio?
Previous by Thread: Re: How to export whole SQL database to MS Excel Workbook
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