ETL (Extract, Transform, and Load) Process

I want to introduce about Microsoft Excel and SQL server integration (ETL process).

First of all Open Excel and then go to Data menu. Now select Get Data and From other sources. Select From Microsoft Query. As per below:

Then connect to Database.

Click Cancel.

And Yes.

And Close.

Now go to File menu and click Execute SQL:

Then write SQL procedure or view and select Database . Now select Execute:

Then select Return Data to Microsoft Excel:

Now you get the output:

It will be helpful for Integrate Microsoft Excel & SQL SERVER.

Thank you for reading ETL process.

Share and Enjoy !

0Shares
0 0

3 thoughts on “ETL (Extract, Transform, and Load) Process

  1. Wonderful blog! I found it while searching on Yahoo News. Do you have any suggestions on how to get listed in Yahoo News? I’ve been trying for a while but I never seem to get there! Thanks

  2. This is really attention-grabbing, You are a very skilled blogger.
    I’ve joined your rss feed and stay up for looking for more of your wonderful post.
    Also, I’ve shared your website in my social networks

Leave a Reply

Your email address will not be published. Required fields are marked *