>Am looking for best ways to overwrite the contents of an SQL Server table with the contents of a dbf table under foxpro v 6.0 program control. Would rather not have to use DTS.
>
>TIA for any suggestions.

Use SQL PassThrough to truncate the SQL Table, then repopulate it from the dbf.

Hope that helps!

-Justin