So it appears that .CopyFromRecordset works very well from within Excel's VBA. I am calling a recordset against a .mdb file and get a return of 739 records. If .CopyFromRecordset is used in Excel's VBA, Bam! there is all my data I expected from the recordset.
I am trying to create a class...