Post reply

Merging sql and excel

  • February 28, 2022 at 11:02 am

    #3990144

    I’m trying to merge sql data and excel data to an excel spreadsheet. Is there a way to do this?

    https://tweakbox.mobi/

     

    • This topic was modified 2 years, 8 months ago by  mahe55.

  • February 28, 2022 at 11:06 am

    #3990161

    SSIS can do it.

    Create a dataflow with

    Source 1: SQL Server

    Source 2: Excel

    Destination: Excel

    Inside your (source --> destination) dataflow, perform the merge, probably using a MERGE JOIN component.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • February 28, 2022 at 3:28 pm

    #3990458

    PowerQuery can get data from your database. then merge. Depends on what tools you have available.

Viewing 3 posts - 1 through 2 (of 2 total)

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