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,222 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
674 reads
By Steve Jones
I have always been interested in GE since I was a kid. My best...
By todd-32417
For Kyla Marie Charles, switching to WordPress.com opened up possibilities for her website and...
I was recently approached at work about a company that was seeing tons of...
Can you advice how to retrieve the DML type a query is running? Does...
Hello Community, I have been given a challenge of converting the following SQL code...
Hi everyone, I have a brother who just graduated with a programming major. And...
Ask SSC