Can I append an acces table through vba.
I have retireved queries through ado and want to create a similar report but I need the user to append table for lastest monthly data each time user runs.
Is it possible to append the table using VBA ADO or someway. I would rather not have the person have to open access themself.
I have retireved queries through ado and want to create a similar report but I need the user to append table for lastest monthly data each time user runs.
Is it possible to append the table using VBA ADO or someway. I would rather not have the person have to open access themself.