>>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".
>
>See http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForMicrosoftJet

An unintended consequence of this link was that I have followed up from there and found a solution to an unrelated problem :). Unfathomable are the ways of electrons, indeed. Thanks all the same.