How to append to existing excel sheet?

captgnvr

EAGER LEARNER
Local time
Tomorrow, 00:06
Joined
Apr 27, 2010
Messages
144
D/All

Crew list in excel is linked to access database.

I am able to filter data in two queries. one will have crew members as on the beginning of month and another query which will have crew joined during the month.

Could you pls tell me how to append the newly joined crew members query to the end of existing excel sheet which has the link to access for crew members who are at the beginning of month??
 
You should import the data into access when ever you need to update your database. Do not link your data, keep all the data in Access.
 

Users who are viewing this thread

Back
Top Bottom