Home Forums SQL Server 2014 Development - SQL Server 2014 Update column data from Linked Server RE: Update column data from Linked Server

  • November 22, 2016 at 11:51 am

    #1914092

    tocy1980 (11/18/2016)

    I have tried this:

    update Server_FINAL

    set Server_FINAL.Parts = [Linked Servers].[DATA STORE LINKED].['ET NEW$'].[Parts Used]

    and it doesn't work.

    Get this error: he multi-part identifier "Linked Servers.DATA STORE LINKED.'ET NEW$'.Parts Used" could not be bound.

    you have to get the linked server working first before you can use it for updates and joins

    does this work at all?

    why did you create a linked server with spaces in the name?

    EXECUTE sp_tables_ex [DATA STORE LINKED]

    SELECT mySheet.*

    FROM [DATA STORE LINKED]...[ET NEW$] mySheet

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!