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