Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  How can I link tables from different databases?

Author  Topic  ScAndal Starting Member 8 Posts Posted - 2001-10-29 : 11:12:06 Here is the situation: I am implementing a software package that uses sql server as its backend. The client has various access databases that contains data that should be moved into the sql database, but he needs them for another year. So I need to create some kind of link between the two databases so that the program I wrote thinks all the data is in the sql database. Can someone help me with information on how to link these together as one table? I have heard you can do it, but multiple searches brought me nothing. Thanks in advance, ScAndal