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

Content with tag ODBC Rss

   Items 1 to 4 of 4   
 

Getting Data between Excel and SQL Server using ODBC

With ODBC, you can summarise, and select just the data you need, in an Excel workbook before importing it into SQL Server. You can join data from different areas or worksheets. You can even get data from the result of a SQL Server SELECT statement into an Excel spreadsheet. Phil Factor shows how, and warns of some of the pitfalls.  Read more...
By Additional Articles 2013/09/05 | Source: SimpleTalk | Category: odbc
Rating:  Rate this |   Briefcase | 4,040 reads

Now you ODBC me now you don't

Phil Factor reflects on Microsoft's "handbrake turn" on OLE DB; Denali's successor will have to have all this plumbing ripped out to replace it with the older ODBC technology. It's a surprising move but makes a lot of sense, given the ubiquity of ODBC drivers for relational data access.  Read more...
By Phil Factor 2011/09/12 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 244 reads

Multiplatform ODBC support for SQLServer

The Microsoft SQL Server Connectivity team has a survey on the need for ODBC support for other platforms. If you use SQL Server from other platforms, let them know.  Read more...
By Press Release 2010/03/04 (first published: 2010/02/25) | Source: SQLServerCentral.com | Category: odbc
Rating: |  Discuss |   Briefcase | 1,920 reads

Multiplatform ODBC support for SQLServer

The Microsoft SQL Server Connectivity team has a survey on the need for ODBC support for other platforms. If you use SQL Server from other platforms, let them know.  Read more...
By Press Release 2010/03/04 (first published: 2010/02/25) | Source: SQLServerCentral.com | Category: odbc
Rating: |  Discuss |   Briefcase | 1,920 reads
   Items 1 to 4 of 4   
 
Tags
database weekly (1)    
editorial (1)    
excel (1)    
microsoft (1)    
survey (1)