How to get the recordset data from Word VBA to excel sheet?

I'm new to VBA, for part of a requirement I need to get the data from SQL table to Excel sheet using Word macro. I tried to

1. Connect to SQL using ADODB connection and created & set an object for recordset
2. I have created and set the necessary excel objects like Excel.Application, Excel.WorkBook and Excel.WorkSheet But I'm stuck with how to get the data from recordset into Excel sheet