Updating Access 2003 Tables from 2 Excel Sheets

Have you tried to write a macro that increments the file using a date attach to the file name that changes when a file is querried.

if i get you correct your [[Excel ] ]=>[[Access ] ]=>[tblAll ]
·······································\_____ _____/
················································\/
············································duplicate
·················································\_____ _____/
··························································\/
······················································triplicate

whatever
before writing a SUB that'd append "New data" to tblAll
i reccommend you
• copy [tblAll ] to another filename or location
• append "New data" to [tblTest ] (containing 1 .. few records in it)
• find/position pair of last matching records in DB copy2 & DB copy3
• transfer/append "New Data" records to DB copy3
• if prev works then ... trivia

i have some access foxpro experience but i don't do std. DB programming
(coz i don't do std. anything too much if any)

Oy, not much help here folks. Lots of reads but few responses.

I checked on a different forum and someone pointed out I should be using the Union Query instead of the Append. Did that and it worked just fine. Hope this helps anyone following this thread.

Thanks for sharing the third party provided solution.