Good Evening,

I just got this project in my hand where i have to export access query record to an existing excel template file. This excel template file has formulas in the bottom. More like total fields. So once i export all the records and its value it will sum up the values and give user a total.

That being said, I Must export the records in proper fields on the excel file. Means, the header of the access query must match the header of the excel files and paste the records in appropriate fields.

I have looked into many forums and found few techniques but i think they are bit different than what i am looking for. Can anyone please tell me, How should i approach this or if you know a good source related to this , can you please show me?


Thanks for your time.
JRayhan