>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
INSERT INTO MYVFPSERVER...TableName (field list) VALUES (value list)
(not tested)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.