[dba-SQLServer] OpenRowset

Database Engine Architect InfoCenter

http://msdn2.microsoft.com/en-us/library/ms175560/(SQL.90/).aspx
then to
About Bulk Import and Bulk Export Operations
http://msdn2.microsoft.com/en-us/library/ms187042.aspx


SQL Server 2005 Books Online
OPENROWSET (Transact-SQL)
Way at bottom text file import examples

http://msdn2.microsoft.com/en-us/library/ms190312.aspx

jwcolby wrote:

>Guys,
>
>I am trying to do the following, straight in a query window in SQL Server
>2005:
>
>SELECT * FROM
>OpenRowset('MSDASQL','Driver={Microsoft Text Driver (*.txt;
>*.csv)};DefaultDir=C:\aTestFTP\;','select * from Infutor1.txt') 
>
>I get the following error:
>
>OLE DB provider "MSDASQL" for linked server "(null)" returned message
>"[Microsoft][ODBC Text Driver] '(unknown)' is not a valid path.  Make sure
>that the path name is spelled correctly and that you are connected to the
>server on which the file resides.".
>Msg 7303, Level 16, State 1, Line 1
>Cannot initialize the data source object of OLE DB provider "MSDASQL" for
>linked server "(null)".
>
>So what did I do wrong this time?  ;-)
>
>John W. Colby
>Colby Consulting
>www.ColbyConsulting.com 
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada