>George,
>
>Maybe the best way is to use SQL Server 2000 DTS to schedule the processing you need from whatever data source and then have it call a small VFP 7.0 app that creates the 2.x dbf file you require. It would do this on a periodic basis.
>
>Althought it sounds complex we have found DTS very easy to setup and integrate with VFP. Maybe this is a case where it is better to look for a solution from SQL towards VFP->FPW rather than FPW->VFP to SQL.
>
>Best of luck,
>
Jim,

Thanks. Normally this or something similar is exactly what I would have done. Unfortunately, I'm still in the position of having to support these applications (which, BTW, I wrote) and have no opportunity to upgrade them.

As I may have written in another part of this thread, I ended up writing a VBScript file to turn the 100,000+ rows into an SDF file and import via the APPEND FROM...TYPE SDF command. The script file is called via ShellExecute() from within the FPW 2.6 application. The script file uses ADO and is incredibly fast in creating the SDF file.