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,219 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
671 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Christmas. Depending on where you live it’s a big deal even if you aren’t...
By Arun Sirpal
Quick Video showing you have to use a BACPAC to “import” a database into...
How do I exclude the "Appointments" that are not adjacent to a "Discharge"? This...
Hi SSC, I've got 2 Project Variables which I use to control wether a...
Hello, I have two simple tables: Invoices InvoiceID Date Value and PaymentsReceived PaymentID Date...
Ask SSC