I would like to be able to paste or insert data from an adodb recordset into an MS Word (2003). I have a Word template that contains several tables that I populate one row at a time from a recordset. The tables start out with two rows, a header row, and a blank row. The first blank row is populated, field by field, then a new row is inserted as needed. This works at an acceptable speed unless the recordset contains several thousand records.
For recordsets that I don't want to modify, is there a way to insert the entire recordset (excluding the header) into a table, starting at row 2? Can it add additional rows automatically?