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,216 reads
This procedure will return useful columns information for VB developers. It shows column name, data type, size, vbtype, checktable (refferenced table) and flags: NoNull, IsIdentity, IsPK.Calling sample: mysp_columns 'customers'
2002-04-19
665 reads
Hey, it’s T-SQL Tuesday again! I almost forgot about it what with Summit and...
By Bert Wagner
This week, I filmed my experience as a first time speaker at PASS Summit...
By Arun Sirpal
A way to enforce good practice and standards is by Azure Policy. As stated...
Casting insight on different aspect of the assembling and configuration part of printer. The...
Comments posted to this topic are about the item Limiting the Data Frame
Ask SSC