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,223 reads

Blogs

Techorama 2022 – Session Materials

By

You can find my slidedeck for the session “Introduction to Azure Data Factory” on...

Daily Coping 24 May 2022

By

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

Notes on SQLSaturday Jacksonville 2022

By

I drove up to Jacksonville Friday afternoon to allow for bad traffic and immediately...

Read the latest Blogs

Forums

Logging sql stms into a table when there is a High cpu alert

By bobrooney.81

Hi, Whenever I get an high cpu alert , be it non-working hours or...

Transactions names meaning In Transaction Logs

By IT researcher

I am using .LDF file to get the information about when was DB last...

Iterate and reorganize subset of database tables

By ktflash

Ahoi, we are using the ola hallengren scripts to run the weekly index optimizer....

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers