ODBC

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

Daily Coping 5 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Microsoft Ignite Announcements 2021

By

Microsoft Ignite has always announced many new products and new product features, and this year...

Daily Coping 4 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Querystore is very slow

By oRBIT

I'm working with a 260GB sized production-database here and working a little bit with...

Assistance needed

By irishnut

I have the need to pull data using a last touched date. Below ins...

use functionality enterprise edition

By abdalah.mehdoini

Good morning all , I must proceed to migrate an instance of 2008 Enterprise...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers