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


2,222 reads


Join me next week at my first GroupBy session


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

Daily Coping 20 Oct 2021


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


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

Read the latest Blogs


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


SQL Server Q&A from the SQLServerCentral community

Get answers