mahe55
SSC Veteran
Points: 217
More actions
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/
Phil Parkin
SSC Guru
Points: 247039
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.
pietlinden
Points: 63535
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