I have written several apps. in VB6 that retrieve, update, and otherwise manipulate
AS/400 data using ODBC. In the past, I have used Access databases with attached
tables (AS/400 files) because in many cases I need to execute multiple-step
processes on data and it made more sense to simply retrieve ONLY the records
that I needed to begin, then handle all other processing locally. Well, I
would like to get away from using attached tables. To do this, I am using
SELECT statements to build ADO recordsets, and I would like a quick way to
'import' these recordsets directly into and Access database.

Does anyone have an idea how this could be done rather quickly?