Problem
When using a recordset as a datasource with the ExcelWriter template object, the cells are not populated with data. This typically happens when the recordset is at EOF due to manipulation in the script. When the template object’s .Process() method is called, the data binding occurs.
Solution
Before calling .Process(), you should move to the first record in the recordset with this command:
oRS.MoveFirst() That way, the recordset will be passed properly to the object.
Share the post "Data not imported when using a recordset for a data source"
Follow