ODBC

External Article

Getting Data between Excel and SQL Server using ODBC

  • Article

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.

2013-09-05

4,816 reads

Blogs

How to Change the Browser Used by SSMS for AAD Auth

By

Did you know that you can change the browser used by SQL Server Management...

Typing with Your Tongue Part 2: Voice Access

By

A few months ago, I wrote a post on how I use voice technology...

Tales From The Field Weekly Wrap Up for the Week of 03-20-2023 & Kiddos Growing Up

By

William, right, 11 years ago the morning of our college tour Hello Dear Reader! When...

Read the latest Blogs

Forums

Usage of #TempTables and an Index in Stored Procedure

By BOR15K

We have a stored procedure, working for yonks, which has a CREATE session temp...

Referencing a table type In Dynamic SQL

By Weegee71

I want to use a table variable in a merge statement using Dynamic SQL...

modify dtsx connection

By roshanbi

Hello Team, kindly advise how to change dtsx connection? below is source details: Data...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers