January 22, 2004 at 5:38 am
I hope this is the right area for this.
I need to link to a foxpro database and update the foxpro data in two specific tables with data from SQL Server 2K.
I have been a little successful.
Could use a connection option being set up prior to updates and closing once done.
Any help is GREATLY appreciated.
-Ron
--Ron
January 22, 2004 at 9:00 am
Piece of cake with VFP6 and later. Set up ODBC access to SQL Server and do a SELECT statement against the SQL Server Table of Interest -- this returns a VFP cursor which can then be posted to the VFP table by whatever logic you want to use.
Arden
January 22, 2004 at 9:02 am
Whoops -- hit enter before I was done -- contact me offline at weissa@libinc.com so I can email you VFP code I use to do-the-do.
Arden
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply