Pentru OPENROWSET, vezi daca "Ad Hoc Distributed Queries" sunt admise pe serverul tau:
sp_configure 'show advanced options', 1
RECONFIGURE
sp_configure
si vezi valoarea Ad Hoc Distributed Queries. Daca e 0,
sp_configure 'Ad Hoc Distributed Queries', 1
RECONFIGURE
Pentru linked server sunt mai multe de incercat
http://connect.microsoft.com/SQLServer/feedback/details/284113/import-excel-data-with-openrowset-on-production-server
http://support.microsoft.com/kb/814398
http://nathondalton.wordpress.com/2010/04/01/sql-memory-and-external-data/
Poti avea acces la datele respective in format csv sau text, pentru bcp?