Re: Looking for examples for link server, excel file

msnews.microsoft.com schrieb:
I have excel file and need to create a link server so I can read excel file from sql2k.

Server where file is residing is SERVER1
Excel file name is ABC
User name is XYZ
password is PASSWORD


and the column that I want to retreive is Price.

I would appreciate if someone please show me an example for Link server

Thanks




EXEC sp_addlinkedserver 'XLSSource', 'Jet 4.0', 'Microsoft.Jet.OLEDB.4.0', 'c:\yourDocument.xls',NULL, 'Excel 8.0'




hth
Stefka
.

Relevant Pages

  • Res: Sendmail multiple domain
    ... I think you cant do that, but you can use a subdomain and virtusertable. ... We have setup one sendmail server with mycompany.com at ABC place. ... Now at XYZ place we need to set the server for mycompany.com only. ...
    (RedHat)
  • Sendmail multiple domain
    ... We have setup one sendmail server with mycompany.com at ABC place. ... Now at XYZ place we need to set the server for mycompany.com only. ... Redhat Channel Partner and Training Partner ...
    (RedHat)
  • SOLVED Re: Sendmail multiple domain
    ... We changed the name of the server. ... We have setup one sendmail server with mycompany.com at ABC place. ... Now at XYZ place we need to set the server for mycompany.com only. ... Redhat Channel Partner and Training Partner ...
    (RedHat)
  • Re: mail to/from multiple domains in 2003
    ... > WE have a server with an internal domain, lets call it abc. ... The xyz domain is a domain we own. ...
    (microsoft.public.exchange.setup)
  • Re: new server and problems with mdw file
    ... What server OS on the new server? ... It was looking like an environmental (network) issue from the beginning. ... It's acting as if the share folder is "shared" but only limited to one user ... - create an excel file, save it, and delete it. ...
    (microsoft.public.access.security)
Loading