With Automation, you can use several approaches for transferring your data: Transfer data cell by cell Transfer data in an array to a range of cells Transfer data in an ADO recordset to a range of cells using the CopyFromRecordset method Create a QueryTable on an Excel worksheet that contains the result of a query on an ODBC or OLEDB data source Transfer data to the clipboard and then paste the clipboard contents into an Excel worksheet
Transfer data cell by cell
Transfer data in an array to a range of cells
Transfer data in an ADO recordset to a range of cells using the CopyFromRecordset method
Create a QueryTable on an Excel worksheet that contains the result of a query on an ODBC or OLEDB data source
Transfer data to the clipboard and then paste the clipboard contents into an Excel worksheet