>Hi,
>
>This my first time using the link server to read the files directly from within SQL2005, so issues the following link:-
>
>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 that i can open query and do the import issues, but how to do insert to the vfp tables
>
>Best regards
VFP linked servers do not support modification. Try using advantage database server or Openrowsource if ole enabled instead.
Cetin