The only thing that I'm aware of that is easier is how MS.NET handles this but then you'd have to farm the recordset out to a MS.NET program.
The only other thing I'd caution you on, depending on the use of this application, is that it if is too generic you can open the door to hackers exploiting the inherent holes it would create. --- "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. > ____________________________________________________________________________________ Don't get soaked. Take a quick peak at the forecast with the Yahoo! Search weather shortcut. http://tools.search.yahoo.com/shortcuts/#loc_weather
