Technical Article

Attach Excel Workbook

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

You rated this post out of 5. Change rating

2002-05-25

2,227 reads

Blogs

PostgreSQL Backup Failure

By

In this blog post I wrote a tip about fixing the PostgreSQL backup failure...

Dynamic Data Masking – SQL Server

By

Use Dynamic Data Masking to protect your data The post Dynamic Data Masking – SQL...

Using ThinOptics to Read Data

By

As I’ve aged, I find myself struggling to read many things in my life....

Read the latest Blogs

Forums

Be Careful with Missing Index Requests

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Be Careful with Missing Index...

GitHub Copilot - Our Best Ally to for T-SQL

By Daniel Calbimonte

Comments posted to this topic are about the item GitHub Copilot - Our Best...

Zero Statistics Sampling

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Zero Statistics Sampling

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers