Sql Server Openrowset Example. ( bulk ‘c:\data\asia.txt’,single_clob) as mytable. Find out how to use the openrowset function for sql server and microsoft access.

This example uses the microsoft ole db provider for sql server to access the authors table in the pubs database on a remote server named seattle1. Exec sp_configure 'show advanced options', 1 reconfigure go exec sp_configure 'ad hoc distributed queries', 1 reconfigure go To run “out of process”, permissons are required on the msdainitialize dcom component, to initialize the provider.