You may try the other way round.
Append all your data to Access first, and take out what is required by Excel.
Then back to Access.
But I don't think Access is suited. There are other Databases around,but ofcourse that means starting from scratch.
BTW,
The above code was also just an example to.
There is a way to re-code a few lines and it will do the Find without having to type in the criteria. The point is though, you are correct when asking for code and such, but racing requirements I think is the least understood.