Is this task possible. I would like to either use a Pivot table to automatically update the query in Access or some other linked method to the query. I want to fully automate to transfer of data from access to excel.
I am no programmer and would like to know if this is possible purely driven from menu commands?? I have tried to use DDE to update the query but it is does not work once I have a different number of rows in the query.
Can anyone help I am running out of ideas for this problem