Technical Article

Attach Excel Workbook

After installing bellow procedure you will be able to easly attach workbook and read data from it.This example shows how to attach excel file (c:\temp\orders.xls) and display data from named range (Table1):Exec mysp_AttachWorkbook 'c:\temp\orders.xls', 'MyOrders'Select * from MyOrders...Table1

2002-05-25

2,222 reads

Blogs

Join me next week at my first GroupBy session

By

2021 has been the year people want to learn about Temporal Tables, it seems....

Daily Coping 20 Oct 2021

By

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

Updated Pluralsight Course – Configuring and Managing Kubernetes Networking, Services, and Ingress

By

My updated course “Configuring and Managing Kubernetes Networking, Services, and Ingress” is now available...

Read the latest Blogs

Forums

SSIS File System Task - Permission Inheritence

By planetmatt

I have an SSIS package which outputs a flat file to the file system...

Rank values based on dates (grouping)

By JeremyU

Hello friends, I need some help. I need to rank all titles for each...

Please help with grouping totals and details

By eluchianic

I am trying to get the same layout going in ssrs as in the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers