Home Forums SQL Server 7,2000 T-SQL Help, unable to update linked Excel File RE: Help, unable to update linked Excel File

  • February 9, 2015 at 5:46 pm

    #1776511

    I realize this post is almost a half decade old but I did come across it while searching for an answer to the very same problem and figure others might, as well.

    The real problem is that the driver is broken, Microsoft has been able to duplicate the fault, admits it needs to be fixed, closed the CONNECT item promising to not let it slip through the cracks, and it's still broken almost 5 years later. Here's the link.

    https://connect.microsoft.com/SQLServer/feedback/details/626965/cannot-update-excel-2007-spreadsheet-as-linked-server-within-sql-2005-or-sql-2008-via-oledb-12-0-provider

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)