merge data from 2 excel worksheets into one word document

[S.Kulshekar]

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?

 

[Doug Robbins - Word MVP]

Combine the two worksheets into one.

--
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

 

[Cindy M -WordMVP-]

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