Hi,

Please help with how can i populate the pivot table in the excel sheet using VBA and ADODB recordset

I also want to know whats the best way to add pivot table in this process to the excel sheet to get the data from the database

Thank you