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

Azure SQL MI License free?

By

A common setup when leveraging the cloud is to use the cloud for Disaster...

Foreign Keys in SQL Data Generator

By

A customer recently asked about using FKs in SQL Data Generator, and I decided...

Humble Bundle of Java Books

By

I try to keep an eye on the Humble Bundle bundles for books. The...

Read the latest Blogs

Forums

Query Execution Modes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Query Execution Modes

The Art of the Code Review

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Art of the Code...

username upper case lower case how to fix

By sqlguy80

there is a field userid, firstname and last name which is allowing such userids...

Visit the forum

Question of the Day

Query Execution Modes

What are the two distinct processing modes that the SQL Server Database Engine can use to process T-SQL statements?

See possible answers