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

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

Mike,

That's a good question. I have to look up the extensions in the Open
command and check this out.

Thanks,


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
URL:      http://www.cosmocom.com


-----Original Message-----
From: Mike Starr [mailto:mikestarr-techwr-l -at- writestarr -dot- com] 
Sent: Friday, December 28, 2007 1:55 PM
To: Ronald Schwarz; techwr-l -at- lists -dot- techwr-l -dot- com
Subject: Re: How to export whole SQL database to MS Excel Workbook

FWIW, I'm not a DBA and don't even play one on TV... this is all pure
speculation based on no experience whatsoever.

Sounds as if you're working from the SQL side... does Excel offer the
option of opening the database rather than an individual table?

Mike
--
Mike Starr                            WriteStarr Information Services
Technical Writer   -   Online Help Developer   -    Website developer
Graphic Designer    -    Desktop Publisher   -       MS Office Expert
Phone: (262) 694-1028 - Tollfree: (877) 892-1028 - Fax:(262) 697-6334
Email: mike -at- writestarr -dot- com      -      Web: http://www.writestarr.com

--------------------------------------------------
From: "Ronald Schwarz" <RSchwarz -at- cosmocom -dot- com>
Sent: Friday, December 28, 2007 11:48 AM
To: <techwr-l -at- lists -dot- techwr-l -dot- com>
Subject: How to export whole SQL database to MS Excel Workbook

> 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 
> mikestarr-techwr-l -at- writestarr -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/mikestarr-techwr-l%
> 40writestarr.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.
> 
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

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.