How to Create a Word Document From an SQL Query

SQL stands for Structured Query Language and is a querying language for modifying and querying data and also managing the database.The database management system includes administrative functions and management. Most of it enables you to enter and execute language commands that are supposed to access the user interface. The database management system can also be used to create a Microsoft Document from a SQL Query

Difficulty: Moderate

Instructions

Things You'll Need:

• ODBC Driver
• Publish Query for Microsoft SQL Server

How to Create a Word Document From an SQL Query

1. Download the ODBC driver and Publish Query for Microsoft SQL Server (see link in Resources). They will be required to create a Microsoft Word document from a SQL Query

2. Run the set up of the Publish Query for Microsoft SQL Server and follow the instructions for installation in the wizard menu. It will detect automatically the correct database and path settings for your system and provide an advanced option for power users.

3. Open the Publish Query interface by selecting the menu option "Publish Query" from the User Interface menu. Left click the desired query to queue the results to save as a Word document.

4. Select the "Run Query" option from the SQL user interface menu and the stored query results will then be written to Microsoft Word.

References

• ODBC Driver Dowload Site
• Microsoft SQL Publish Query Software Home Page

Resources

• ODBC Driver Dowload Site