Run SQL Queries on Excel Sheets

author-image
CIOL Bureau
Updated On
New Update

Data in an organization is typically stored on multiple platforms and
formats. A lot of useful data, however, is stored in non-traditional databases,
such as e-mail (plain text) and Excel worksheets; besides DBMS and RDBMS
systems, like Access, DB2, SQL Server and Oracle. Analysis of such data becomes
difficult in the absence of a method to collect them at one place without
needing to first convert them. Here's where a feature like MS SQL Server's
'linked server' helps you perform centralized information analysis from
disparately stored data.

















Direct Hit!
Applies to:
Database administrators
USP: Analyze
data lying in multiple databases and Excel Sheets 
Primary Link: href="http://msdn.microsoft.com/library/en-us/adminsql/ad_1_server_4uuq.asp">http://msdn.microsoft.com/library/en-us/adminsql/ad_1_server_4uuq.asp
Google keywords:
mssql linked
server 

True, there is another feature in MS SQL that can be used-Replication. But
this is generally not advisable especially when the data sets are large.
Replication is used where there are smaller data sets and the subset of the data
to be used is well known. What Replication does is, it moves the data from one
database to the other. Whereas in linked servers, the data is not moved anywhere
else, instead it is directly accessed or modified from the original location
itself. In this article, we'll discuss about linked server and how you can make
use of it in a typical scenario. 


What is a linked server?
Linked server is an alias on your SQL
Server instance that points to an external data source that can be anything from
a plain text file to another RDBMS database. This link works over an OLE or ODBC
transport layer. The database can be accessed directly from the SQL Server. You
can code your applications to fetch data from an external database, using this
link. This technique is similar to the 'linked table' feature in MS Access. 

Advertisment

For more please visit: PCQuest

tech-news