How about saving the recordset as XML and then importing it into Access: http://support.microsoft.com/kb/q285329/
Good luck, Peter Hoogenboom --- In [email protected], "Databasedude.com" <[EMAIL PROTECTED]> wrote: > > A custom object returns an ADO recordset to Access. I'd like the > contents to be inserted into a table as quickly and efficiently as > possible. > > I know that this can be accomplished by looping thru the records, but > I was curious whether there was a more efficient operation. > > I'm particularly interested in any solution that could be as flexible > as possible, in the event that the object design is updated & a > recordset containing additional or differently named fields is then > returned. > > Thanks in advance! >
