On 2002-05-07 13:00, Mark W. wrote:
On 2002-05-07 11:58, dotswife wrote:
I need to merge 2 documents. When I do, there will be duplicate entries. What is the easiest and most accurate way to eliminate the duplicated entries?
Use Excel's Data | Get External Data | Create New Query... menu commmand to treat each Named Range as a separate table (e.g., Table1 and Table2) using the Excel ODBC driver and a SQL statement such as...
SELECT Table1.Field1
FROM Table1 Table1
UNION
SELECT Table2.Field1
FROM Table2 Table2
This message was edited by Mark W. on 2002-05-07 13:01