Forum Discussion

Mirko Hršak's avatar
Mirko Hršak
Copper Contributor
Nov 11, 2017
Solved

select data from SQL database by criteria in column A

I need to add some new atributes in existing excell worksheet for employees.  Lets say that  column A  containing employee id , and there is existing colimn B, C, D . Now i need to connect to SQL se...
BI & Data Analysis
excel
Excel Online
Formulas and Functions
Macros and VBA
  • Wyn Hopkins's avatar
    Wyn Hopkins
    Nov 12, 2017

    Hi Mirko

     

    I'd potentially use Power Query to pull the data from your existing Excel Table and from your SQL server then merge the 2 sets of data and load back into Excel in a new Table.

     

     

Wyn Hopkins's avatar
Wyn Hopkins
MVP
Nov 12, 2017

Hi Mirko

 

I'd potentially use Power Query to pull the data from your existing Excel Table and from your SQL server then merge the 2 sets of data and load back into Excel in a new Table.

 

 

Mirko Hršak's avatar
Mirko Hršak
Copper Contributor
Nov 13, 2017

Thnx,

 

i have used DTS integration tool (SSIS)
source excell 

lookup with query on sql database and output as excell.

Resources