[dba-SQLServer] OpenRowset

The openrowset is for linked servers.
Think of it as the same as linking an entire database
at once in Access.

If you go to server object in the object browser, you
will see linked servers.  You can use the text oledb
or (I think odbc drivers to link the text file from
there.

Robert

At 12:00 PM 7/3/2007, you wrote:
>Date: Mon, 2 Jul 2007 15:42:15 -0400
>From: "jwcolby" <jwcolby at colbyconsulting.com>
>Subject: Re: [dba-SQLServer] OpenRowset
>To: <dba-sqlserver at databaseadvisors.com>
>Message-ID: <20070702194226.6EDB3BD56 at smtp-auth.no-ip.com>
>Content-Type: text/plain;       charset="us-ascii"
>
>I would take it you are right.  The file is just a (CSV) file.  It is on a
>mapped drive.  What is this "linked server" and why do I need one to open a
>file?
>
>
>John W. Colby