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 server where i can select new atributes to put in column G,H,J using simple query like
select EmployeeID, DepartmentCode, Department from [dbo].[vRadniciSP] where EmployeeID = (value from column A row by row for each employee id) .
How to manage that?
Connection "*************************"
database dbEmploye

  • 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.

     

     

2 Replies

  • 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

      Thnx,

       

      i have used DTS integration tool (SSIS)
      source excell 

      lookup with query on sql database and output as excell.

Resources