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 21 Sep 2021

By

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

#PowershellBasics: Bulk insert.

By

In my last post I talked about invoke-sqlcmd. It’s a nice easy way to...

Lambda Architecture in data systems and possible meaning of this name

By

(2021-Sep-21) There is one scene in "The Core" movie that I really like when two geophysicists...

Read the latest Blogs

Forums

Azure data factory tutorials

By browlciba

Hi all I was wondering if anyone knows where to go for help with...

The actual file SQLServerManager15.msc is missing from my computer

By Jocar26

I did a fresh install of Windows 10 Pro and loaded SSMS on it. ...

PostgreSQL Date And Time Part 2

By Shivayan Mukherjee

Comments posted to this topic are about the item PostgreSQL Date And Time Part...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers