I have a program that gets data from sql server and puts it into vfp tables (free tables). From there reporting is done against the dbfs. This needs to be done multiple times a day. One table, tblactivity, has about 500K records.

Regarding the following code:
lnr=sqlexec(lnh,"select * from tblactivity","curactivity") && takes 30 or 40 seconds
copy to tblactivity_vfp && takes a few minutes?? haven't benchmarked exactly, but it is slow

Is there a way to speed this up? Years ago I used BCP, don't remember much about it right now, but thinking it would speed up writing to a text file, but then I'd have to append into a dbf anyway.

Is there any way to bypass sending results to a cursor first, a way to use sqlexec to go straight to a dbf?
Any way to speed up the copy to?

Thanks.