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.