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
|