HI Im very new in VBA and also to the forum. Im having some difficulty and hope someone can help me with it.

I have,say 7 Excel table template, which I need to get the data from Access, into the respective column in Excel, pertaining the format.

I have created a macro, to append the data, column by column, from Access to data. But this wouldnt work on other Acess table, who has different column and different tables.

Can someone gve me some tips on how to go about it?