Posted by John Borders on December 12, 2001 7:24 AM
I have created a reference to DAO object library 3.6
and have been successful in opening an Access database using an Excel macro. However when I do to copy a table from the database into Excel, I only get one record from the table, not all of them. I am using
the error msg is: Method 'CopyFromRecordSet' of object 'Range' failed.
Any idea why it stops after copying only one record?