SQL Server link to access/excel

[henslecd]

My company has two servers, "A" and "B". "A" has SQL Server on it with data, "B" has more data.

I am wondering if I can link SQL Server to "B" and get the data from there. I cannot import this data to "A". It must stay on the "B". The data on "B" could be an excel spreadsheet, an Access table, etc etc. Is there a way to link the data on "B" to SQL Server on "A"?

Thanks for the help.

 

[MaffewW]

you can query data on a remote server. first you need to add the server as a linked server (like linking tables in access)

look up sp_addlinkedserver in BOL

you can then query the data from server A by fully qualifying the name of server b eg
select * from serverb.databasename.dbowner.tablename

Matt

Brighton, UK