>Nadya,
>
>I am assuming your are using SQL Server as the database and you have th eSQL statement in a stored proc.
>
>Use SQLExec to execute the stored proc and save the resukts to a cursor. Then use :
> COPY TO *filename* SDF
>
Thanks, Ken. I save your answer for the future.
>
>>Hi everybody,
>>
>>I have this problem, which I'm seeking the best solution. I want to extract ~2mln. records from database into SDF file. I can do it in one SQL, but it produces first line with Field names. I don't want them. What's the best way to get rid on field names? Do I need to go SQL into table then copy to file?
If it's not broken, fix it until it is.
My Blog