>Thanks for the suggestions, Tim, Hugo and Kevin
>I did some tests and the Linked Server takes at least 10 times as long to execute a query as it takes fill the datatable using execute reader when I query one record from the table using an indexed field.
>The Linked Server couldn't be easier to use, but that performance hit would blow the project out of the water.
>It seems that the execute reader lets the OLEDB provider use the index - it's almost as fast as VFP with Rushmore, while the Linked Server query seems to be scanning the whole table.
>I haven't tried SSIS yet, but I will
>Thanks again for the tips
Bill, if you have tables from both sources already in dot net DataTables it isn't that difficult to put them in a DataSet together and then add a relationship. Maybe I misunderstood that part. Depending on how you are getting your two DataTables, you could just modify that and add the first to a DataSet and then add the second retrieval into its own table but in the same DataSet. Then set a relation.
Tim
Timothy Bryan