Can Queries be imported into MS Word for Reports?

[Shinken]

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

 

[mikey69]

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.

 

[vree9638]

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

http://wwww.helenfeddema.com,

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.