Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Sheila Mae Sentin
  Where is Sheila Mae Sentin?
 Sheila Mae Sentin
 To: Boudewijn Lutgerink
  Where is Boudewijn Lutgerink?
 Hoonaardstraat, Driel
 Boudewijn Lutgerink
Subject: RE: Recordset to DBF
Thread ID: 112297 Message ID: 112310 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: ODBC, ADO and OLEDB
Date: Tuesday, November 07, 2006 8:59:08 AM         

Hi Mr. Lutgerink. Did just what you said and it worked pretty well. Got another question - why did vfpcom convert all the text fields in the .MDB to memo field type in the cursor? Is there a way to retain the field types to their originals?
Thank you. :)

> > Hi Foxiters. Do you know how to transfer all the records of a recordset into a different .dbf file?
> >
> > I will appreciate very much your help.
> >
> > Thank you.
> >
> > Sheila

> download the vfpcom utility from the MS site here. Install it. In that package is a function rsToCursor() that transforms a ADO RS to a VFP Cursor (among others).
> Boudewijn LutgeĀ®ink
> The attitude of "An eye for an eye and a tooth for a tooth" will make this world toothless and blind (Ghandi)


Recordset to DBF Posted by Sheila Mae Sentin @ 11/7/2006 7:59:27 AM
RE: Recordset to DBF Posted by Boudewijn Lutgerink @ 11/7/2006 8:20:22 AM
RE: Recordset to DBF Posted by Sheila Mae Sentin @ 11/7/2006 8:59:08 AM