Hi Steve,

Can you provide more details? Is it one time deal or repeating task? How do you retrieve data from SQL Server (SPT, ADO, DTS) ?

>I need to retrieve data from large SQL tables into multiple under 2G dbf files. At one time I knew how to do this, but I've lost it. I know I used cursors in a script like
>
>

>DEFINE MyCursor CURSOR FOR
>SELECT * FROM BigOleSQLTable
>
>OPEN MyCursor
>
>FETCH NEXT FROM MyCursor
>WHILE @@FETCH_STATUS = 0
>   FETCH NEXT FROM MyCursor
>  BEGIN
>END
>
>CLOSE MyCursor
>DEALLOCATE MyCursor
>

>
>Can somebody help me flesh this out to create multiple result cursors. Thanks.