DAO CopyFromRecordSet
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
[A2].CopyFromRecordset rst
the error msg is: Method 'CopyFromRecordSet' of object 'Range' failed.
Any idea why it stops after copying only one record?
Thanks jborders@qac.org
Posted by Dank on December 12, 2001 8:25 AM
Hello,
It's hard to diagnose your problem without seeing the rest of your code. Could you post it?
Regards,
Daniel.
Posted by John Borders on December 12, 2001 12:24 PM
Yes, Thank you very much for taking a look at it. Here it is:
'
Dim dbs As Database, rst As Recordset
'
Set dbs = OpenDatabase("c:\winnt\profiles\jborders\desktop\northwinds.mdb")
Set rst = dbs.OpenRecordset("Employees", dbOpenDynaset, dbReadOnly)
[A2].CopyFromRecordset rst
dbs.Close
'
