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

EightKB 2024 – Schedule and Registration

By

Hello Hello, We. Are. Back! The schedule for EightKB 2024 Edition has been announced!...

Inside SQL Server Backup and Restore History Pruning with sp_delete_backuphistory

By

I had a customer that was looking to document a restore that had occurred...

T-SQL Tuesday #176: That Piece of Technical Advice for the Past Me

By

DIVERSIFY! We devote a lot of time to mastering the technology that we are...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers