merge data from 2 excel worksheets into one word document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

S.Kulshekar - 31 Jul 2006 20:03 GMT

I have two excel worksheets. They contain data pertaining to two different
years.
The fields are identical. I want to merge the data from both the worksheets
side-by-side in one word document. Mail merge seems to take only one data
source for a document. Any ideas?

Reply to this Message

Doug Robbins - Word MVP - 31 Jul 2006 20:57 GMT

Combine the two worksheets into one.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have two excel worksheets. They contain data pertaining to two different
> years.
> The fields are identical. I want to merge the data from both the
> worksheets
> side-by-side in one word document. Mail merge seems to take only one data
> source for a document. Any ideas?

Reply to this Message

Cindy M -WordMVP- - 01 Aug 2006 10:33 GMT

Hi =?Utf-8?B?Uy5LdWxzaGVrYXI=?=,

> I have two excel worksheets. They contain data pertaining to two different
> years.
> The fields are identical. I want to merge the data from both the worksheets
> side-by-side in one word document. Mail merge seems to take only one data
> source for a document. Any ideas?

It's possible, but may be more work than Doug's suggestion:

You can use MSQuery and write the SQL for a UNION query. The SQL would look
like this, for example:

SELECT `Sheet1$`.Lastname, `Sheet1$`.Firstname
FROM `C:\Test\UnionMerge1`.`Sheet1$` `Sheet1$`
UNION
SELECT `Sheet1$`.Lastname, `Sheet1$`.Firstname
FROM `C:\Test\UnionMerge2`.`Sheet1$` `Sheet1$`

You can access MS Query from the "Tools" menu in the Open Data Source dialog
box.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

Reply to this Message

Rate this thread: