JOIN two objects from different sources
-
Hi all, I have a situation where I have a table in my SQL Server 2000 database, and another table stored as a .csv file. I would like to perform a join on the two tables. Is it possible to do this without entering the data in the .csv table into the SQL Server database? I am using C#.NET for this stuff. Cheers, Michael
-
Hi all, I have a situation where I have a table in my SQL Server 2000 database, and another table stored as a .csv file. I would like to perform a join on the two tables. Is it possible to do this without entering the data in the .csv table into the SQL Server database? I am using C#.NET for this stuff. Cheers, Michael
I haven't tried this for a text file, but give the Link Server a try in the enterprise manager. If I remember correctly the syntax is as follows: select * from linkserver...tablename. Michael I firmly believe that any man's finest hour, the greatest fulfillment of all that he holds dear, is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious. Vince Lombardi (1913-1970)