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,217 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
669 reads
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Will Assaf
Looking forward to presenting with my wife Christine Assaf our talk on Ethics in...
By Tim Radney
Early this afternoon I received an email from Microsoft presenting me with the 2020-2021...
Today’s tip is share a happy memory with someone who means a lot to...
One of our stored procs has been running for more than 4 hrs. and...
I am working an exercise problem where the solution provided has a WHERE clause...
Ask SSC