May 21, 2008 at 10:42 am
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
May 21, 2008 at 10:53 am
I have never tried to insert into a VFP database, but I would assume (always remembering what assume means) that you could just do something like:
Insert Into linkedserver.database..table
(column list)
Select ....
I'm not sure what the 4-part naming is for VFP linked servers.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 22, 2008 at 12:45 am
hi,
it is not; he cannot see the server link ?
I have an error :-
Invalid object name 'servername'
query select I have no Problems.
Best Regards
May 22, 2008 at 6:51 am
Can you post an example of a working select?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 22, 2008 at 2:53 pm
Hi,
it is my mistake, i forgot the two .. before the table name , THANK YOU
Best Regards
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply