Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  Insert to vfp tables

Author  Topic  issam Starting Member 30 Posts Posted - 2008-05-21 : 12:43:42 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