Getting ADO recordsets into Access database
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?
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL