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,214 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
This is something I touched on back in 2017 a little after the Live...
In my home lab I have an Ubuntu virtual machine that runs both SQL...
By Arun Sirpal
I am not sure when this became available but for Azure SQL Database 150...
Comments posted to this topic are about the item Is Data the Future of...
I am looking for a good solution for automating the deployment of SSIS packages...
Hi Hope to explain this correctly I have some XML data that can vary...
Ask SSC