Sunday, 11 March 2012

Connect from SQL server to Excel file

Is it possible to connect from SQL server directly to .xls file ?
I imagine someting like opening .xls file in Query Analyzer to perform slect
into You can use a linked server. Take a look at this topic from Books Online
"sp_addlinkedserver"
http://msdn.microsoft.com/library/d... />
a_8gqa.asp
Cristian Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET
"Mikus" <Mikus@.discussions.microsoft.com> wrote in message
news:CFDDF854-1800-4B8A-ABBA-3AE7BAB55E32@.microsoft.com...
> Is it possible to connect from SQL server directly to .xls file ?
> I imagine someting like opening .xls file in Query Analyzer to perform
> slect
> into |||In addition to using a Linked Server as Cristian suggested, you can also use
the OPENQUERY command.
--Brian
(Please reply to the newsgroups only.)
"Cristian Lefter" <nospam_CristianLefter@.hotmail.com> wrote in message
news:eeETVNHsFHA.1172@.TK2MSFTNGP11.phx.gbl...
> You can use a linked server. Take a look at this topic from Books Online
> "sp_addlinkedserver"
> http://msdn.microsoft.com/library/d...>
dda_8gqa.asp
> Cristian Lefter, SQL Server MVP
> MCT, MCSA, MCDBA, MCAD, MCSD .NET
> "Mikus" <Mikus@.discussions.microsoft.com> wrote in message
> news:CFDDF854-1800-4B8A-ABBA-3AE7BAB55E32@.microsoft.com...
>

No comments:

Post a Comment