Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 07-14-2012, 10:21 AM
SQLUSA SQLUSA is offline Include Excel Tables in Book Document Windows 7 64bit Include Excel Tables in Book Document Office 2007
Competent Performer
Include Excel Tables in Book Document
 
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
 

Tags
tables



Similar Threads
Thread Thread Starter Forum Replies Last Post
Include Excel Tables in Book Document editing of images, tables and caption in the whole document. Jamal NUMAN Word 4 07-08-2011 04:14 AM
Include Excel Tables in Book Document Copying Multiple tables from excel into a single word document dineshtgs Word Tables 1 04-07-2011 01:27 AM
Include Excel Tables in Book Document VLOOKUP in Excel with grade book. Sailorcancer Excel 3 04-15-2010 09:55 PM
Looking for technical reviewer for Excel book kbnotes Excel 0 01-19-2010 07:46 AM
Linking Excel Pivot Tables in a Word Document wmarsh3561 Word Tables 0 11-17-2009 06:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:16 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft