Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag OpenDataSource Rss

   Items 1 to 4 of 4   
 

My favorite way to access Excel files

Using opendatasource to retrieve data from Excel files as if querying a table.  Read more...
By Gaby Abed 2011/03/22 | Source: SQLServerCentral.com | Category: bcp
Rating: |  Discuss |   Briefcase | 11,380 reads

Using OpenDataSource - SQL School Video

The OPENDATASOURCE command is used for adhoc access to other servers or files in a filesystem. MVP Andy Warren shows how you can quickly use this to access data in other sources.  Read more...
By Andy Warren 2009/04/09 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 2,509 reads

My favorite way to access Excel files

Using opendatasource to retrieve data from Excel files as if querying a table.  Read more...
By Gaby Abed 2011/03/22 | Source: SQLServerCentral.com | Category: bcp
Rating: |  Discuss |   Briefcase | 11,380 reads

Reading Ad Hoc Text Files with OpenDataSource

Discusses the techniques and reasons to use opendatasource for reading text files in SQL Server 2005.  Read more...
By Timothy A Wiseman 2007/12/13 | Source: SQLServerCentral.com | Category: opendatasource
Rating: |  Discuss |   Briefcase | 8,089 reads
   Items 1 to 4 of 4   
 
Tags
bcp (1)    
excel (1)    
text files (1)    
video (1)