Merging sql and excel

  • 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, 11 months ago by  mahe55.
  • 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.


  • 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