Hi!

DTS is 2 times slower than BCP+converting VFP table to text format.
You can also run an INSET statement with data get by OPENROWSET() from VFP table to SQL Server that is also quicker. DTS do 2 OPENROWSETs, one to query data and one to save data. That is why it twice slower than a single OPENROWSET on SQL server. We did speacial investigate for that on the DBF table with 74,000 records and 130 fields when getting only 25 fields from it, all fields are character with average length 20.

Anyway, DTS is recommended by MS because it is COM-based, more flexible and more reliable compare to, say, BCP tramsfer from text file (we spent some time to make VFP->TXT conversion more reliable for character data).

>Besides BCP that Vlad mentioned, you could use Data Transformation Services (DTS) that come with SQL Server to import data. In general BCP is more efficient, but DTS is easier to use...depending on your scenario.
>
>You could also write your own VFP program that reads your flat file and sends SQL Statements (SQL-pass through) to insert your records.
>
>
>>To All,
>>
>>Is there a way to port data directly into a SQL Server data table? For example, if I had a flat file that I parsed using a set of C functions or methods, is there a way I could get the results, still in memory directly into a SQL Server database?
>>
>>Just curious.
>>
>>TIA,
>>Thom C.