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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy