Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can Queries be imported into MS Word for Reports?

Status
Not open for further replies.

Shinken

Technical User
Aug 26, 2002
155
US
Is there any way to bring data from queries into MS Word?

I need to create lengthy, verbose reports, that include charts and selected data from an Access database. Microsoft Word is much better at this type of report, as they are essentially Word documents with graphs and selected data inserted into the report.

FYI, I'm using Office XP and the included versions of Access & Word.

I can import tables into Word from Access, but cannot import Queries. The information needed for the report, however, must be query-based, because the data is in multiple related tables in Access.

Thanks,

Shin
 
Can be done - the most efficient way is to use VBA coding and either ADO (preferred in XP) or DAO (available in XP and backward compatible.
 
You can set up your Word Document Report as a template, then link that Template to Access in a variety of ways. You can use mail mege and insert information into the report, or you can use ADO and pull info from the recordset into Word.

check out this site
code samples, 4 ways to merge to Word.

The code samples are very good and so are the examples. If I can help more, let me know. Good luck.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top