>I have not used a "linked server" before as I have worked only with fat fox clients the last 10 years. Can you give me a link to a resource? Is fox or Sql your linked server?
>
>Thank you.

SQL server linked server pointing to VFP. ie:

EXEC sp_addlinkedserver 
    @server = N'myVFPServer',  -- Your linked server name here 
    @srvproduct=N'Visual FoxPro 9',  -- can be anything 
    @provider=N'VFPOLEDB', 
    @datasrc=N'"C:\PROGRAM FILES\MICROSOFT VISUAL FOXPRO 9\Samples\data\testdata.dbc"'

After creating the linked server you can do something like this (works almost at the same speed with SqlBulkCopy and doesn't have other awkward errors that SqlBulkCopy has):

select * into SQLTable1
  from OpenQuery(myVFPServer, 
  'select * from myTable')

Cetin