Post reply

sp_addlinkedserver and Excel

  • August 26, 2004 at 9:20 am

    #86352

    I have setup a stored procedure that utilizes sp_addlinkedserver and sp_addlinkedsrvlogin to connect to an Excel Spreadsheet.

    It works well. I see my linked server on my SQL Server Enterprise Manager.

    The problem that I am having is that my linked server does not recognize the worksheet within the spreadsheet as a table. This results in my linked server containing no tables.

    Does anyone have any ideas of what I should look at to resolve this issue?

  • August 26, 2004 at 9:34 am

    #520742

    John,

    Have you tried drilling down through EM to "see" what tables exist??

    You should be able to see Sheet1$, Test$ etc.

    and refer to it as test...Sheet1$



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • August 26, 2004 at 9:36 am

    #520743

    Yes, the linked server to the spreadsheet displays no tables.

  • August 26, 2004 at 1:27 pm

    #520773

    The issue was that the Excel file was residing on the hard drive of the client instead of a server. Once I moved it to the server all of my troubles disappeared!

  • September 8, 2004 at 5:44 am

    #522095

    to make path on any other machine write something like this

    \\MachineName\D$\FileName.xls

    i hope this help u


    Alamir Mohamed
    Alamir_mohamed@yahoo.com

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply