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


What the ???? T-SQL Tuesday #120


Hey, it’s T-SQL Tuesday again! I almost forgot about it what with Summit and...

First Time Speaking at PASS Summit


This week, I filmed my experience as a first time speaker at PASS Summit...

Azure SQL Best Practices?


A way to enforce good practice and standards is by Azure Policy. As stated...

Read the latest Blogs


What is the reason behind Driver unavailable error in window?

By Jeromeassistant

Casting insight on different aspect of the assembling and configuration part of printer.  The...

Limiting the Data Frame

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Limiting the Data Frame

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers