devxlogo

September 12, 2003

Use CopyFromRecordset With ODBC Recordsets

You can create an ODBCDirect recordset for use with the Excel Range objects CopyFromRecordset method by using the DAO.Connection objects OpenRecordset method: Public Function CreateDaoRecordset( _ ByVal sDataSource As String,