Extract info from SQL Server to MsExcel
I want to share with you, what do you do to extract info from SQL Server to MsExcel.
You have to follow this steps:
1.- create a New View in SQL.
You have to write a query (this is a single example):
SELECT docnum, doctotal, cardcode, cardname
WHERE docdate between getdate()-30 and getdate()
this query show you the invoices saved in last 30 days.
2.- Go to MsExcel –> Main Menu –> Data –> other sources –> from SQL server
3.- clic on: From SQL Server
In this windows, you have to write a loca IP of your server of SQL. In my case is 10.10.1.4
You have to write a user (in my case the user is INFO), write a password.
clic in NEXT bottom
4- Select the database where you saved your view
and (below) Select the view
5.- clic on finish bottom
6- clic on OK
7- The result of your SQL View, show on msExcel
8- Ready. You have a SAP information from your SQL Database on MsExcel.
9- If you want to refresh the information, you have to go to:
msExcel Main Menu –> Data –> update all
in the windows that apear you have to write
user (in my case the user is “info”)
clic on OK.
And the info on msExcel from your SAP database will be updated.
Note: the user info and the password you have to create on SQL Server like a security login. (I show you in the image below)
I hope that it help you.