insert rows into Excel database
 

Hi - hope someone can help.

I have multiple workbooks that have the same table format. I am trying to
consolidate all unique records into one workbook. Each row has a primary key
for all workbooks. Does anyone have suggestions on a code to
a. insert new records after running a query
b. update existing records if so warranted?

Thanks greatly.

CJA