Excel macro to Append to Access Table

[gophman]

I'm still fairly a beginner with vba in general, but have managed to do a few things. I'm interested in a way to use vba to append data to an access table from excel. I'll have to do this for multiple different reports. I have multiple reports that I run via IBM's Cognos Impromptu to which export straight to an .xlsx file. This data I am then wanting to have a macro written on my personal.xlsb that will run and update an access table (I will do this for the different reports). Then the various access tables I have connected to a powerpivot report where I'm building multiple pivotcharts over all the various data. If someone has a nicer way to do this also I'm all ears!!! I do not have access to the back end databases that the cognos data is pulling from so I can't connect straight from there to powerpivot or else I would. Hopefully someone can help me resolve this issue! One other thing is that the data will have a variable amount of rows when it spits out the report. The columns are formatted already to the way that they should be since I built the reports!

Any help would be greatly appreciated and sorry this is my very first post so I'm hoping someone can help me out!

Thanks!