Forum Discussion
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šakCopper Contributor