OpenDataSource and OpenRowSet Example

--ACCESS SQL SERVER FROM QUERY ANALYSER

SELECT * FROM OPENDATASOURCE('SQLOLEDB','Data Source=192.168.1.3;User ID=sa;Password=shore').[Save].dbo.Material

--ACCESS MSDB DATABASE

SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','D:\pacetam\Dbase\Trn0109.mdb'; 'admin';'',Trn0109)