Subject Re: Copy table from server to local table... From Mervyn Bick <invalid@invalid.invalid> Date Wed, 22 Feb 2017 22:04:43 +0200 Newsgroups dbase.getting-started On 2017-02-22 9:44 PM, Jose wrote: > What is the fastest way for get data from SQL Server and copy to DBF table with dBase code? > > I pose the question differently ... > > I want to take only a part of the data in SQL Server (very small), to perform calculations locally. > > For example: > > SELECT * FROM dbo.Assignees WHERE nId_Assignee=2016 > > Have a look at updateSet class in the help file.  This has an example of exactly what you need. If you are going to copy more than one table you need to null u after each table. Mervyn.