Results 1 to 4 of 4
  1. #1
    Join Date
    May 2003
    Posts
    9

    Question Unanswered: Merging from multiple tables in access db to one msword doc

    I'm trying to create a general msword document that can be merged to by multiple tables (from the same access database)

    For example, the data from "Business_Buyers" and "Industrial_Lessees" could be merged to the same document. I'm not trying to merge more than one table to the document at the same time though, all i'm trying to do is make a generic document that all tables or queries can merge to. Any ideas? I probably should be posting this in an msword forum...

  2. #2
    Join Date
    Jan 2004
    Location
    Romania - Bucharest
    Posts
    50
    I think you should create a Union Query with data from your two tables; the you could export the sresult of the query to Word. Is it what you are looking for?

  3. #3
    Join Date
    May 2003
    Posts
    9
    Not quite, the data of these tables is completely separate. The key to my problem is more the Word doc than anything else. Perhaps I need to create a Word doc for each and every table? This is something i was trying to avoid... :-(

  4. #4
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004

    Re: Merging from multiple tables in access db to one msword doc

    I'm trying to create a general msword document that can be merged to by multiple tables (from the same access database)

    Glen,
    Go ahead and do the WordMerge from Access and include the data from one table. Then go to the next table and do WordMerge again but this time choose "Link your data to an existing Word document" and choose the document you created for the first table. Give it a whirl and see if this gives you the results you're seeking.
    Bud

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •