Wednesday, March 7, 2012

Join sql with access

Hi
How can join 2 diferents databases, one in sql and other in access to make only one sql comand?

If you want to do this from SQL Server the process is called creating a linked server. And then you'd run adistributed query to access the data. SeeAccessing and Changing Relational Data - OLE DB Provider for Jet in Books Online.
If you want to do this from Access the process is called creating a Link Table.

No comments:

Post a Comment