>What is the best way to join a remote table (SQL Server) with local (VFP) data. I'm thinking of creating an XML file (conting VFP data) using cursortoxml() & having a stored proc. in SQL join this with it's own table. Is this a possibility & is it the way to go? If someone could point me in the right direction I'd appreciate it. The problem is that I'd like to migrate some tables to SQL, but not all at once.

Hi Lou,

Check Re: Sending a list from vfp Message #829213 and Re: Table as Variable, passing from VFP to an SQL SP. Message #788283