I am using VFP to connect to a remote data and the generic process returns and ADO record set. This fits in nicely when attaching the ADO recordset to an Excel Pivot Table pivotcache object.

Now I need to take that same generic ADO record set except this time I need to create a Microsoft Access database. Did some research but did not see how this can be achieved but I feel certain someone here has "been there and done it".

Any help will be greatly appreciated...