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/default.asp?url=/library/en-us/tsqlref/ts_sp_adda_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/default.asp?url=/library/en-us/tsqlref/ts_sp_adda_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 :)
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment