join imported Excel 2007 files

[Dayle]

I have two Excel 2007 files that I need to join to form one spreedsheet of
data.
I have the unique identifier column in both files.
There will be some records (rows) that are in one file but not in the other
that need to be kept as well.
How can I pull all of this data together using the unique identifier column
in both files? (82,000 records)

 

[Ashish Mathur]

Hi,

Refer to this article

http://datapigtechnologies.com/blog/index.php/using-access-to-combine-multiple-excel-files-method-2/

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com