View Single Post
 
Old 07-14-2012, 10:21 AM
SQLUSA SQLUSA is offline Windows 7 64bit Office 2007
Competent Performer
 
Join Date: Jun 2012
Location: NYC
Posts: 136
SQLUSA is on a distinguished road
Default Include Excel Tables in Book Document

In my SQL book I have many tables, result of queries, usually 5-10 lines.

I kept loading them as text and tabbing them out myself.

Now I am thinking, it would be wise to export to Excel and export Excel to Word. The only downside, sometimes Excel reformats the data such as date&time, and that requires additional work to undo it.

Another issue, the document is B&W, and Excel introduces blue borders. I had to do properties to change it to black. Is there a solution?

Here is some sample data which I got tired tabbing, and went for Excel:
name schema_id principal_id PrincipalName
dbo 1 1 dbo
HumanResources 5 1 dbo
Person 6 1 dbo
Production 7 1 dbo
Purchasing 8 1 dbo
Sales 9 1 dbo
guest 2 2 guest
INFORMATION_SCHEMA 3 3 INFORMATION_SCHEMA
sys 4 4 sys
db_owner 16384 16384 db_owner
db_accessadmin 16385 16385 db_accessadmin
db_securityadmin 16386 16386 db_securityadmin
db_ddladmin 16387 16387 db_ddladmin
Reply With Quote