Importing SQL Server table to MS Excel 2007 and Higher

The previous post was about importing Excel to SQL Server. This post will guide you to do the reverse, SQL Server tables to Microsoft Excel. The slideshow below would guide you through the steps involved in importing SQL Server table to MS Excel 2007 and higher versions.

The steps involved are

  1. Open a fresh sheet in excel
  2. Go to the data tab in the ribbon
  3. Select “From SQL” in the “From Other Sources” menu
  4. A Wizard will open. Follow the steps shown in the above slide show for selecting the SQL Server database and table and click finish
  5. This will import the desired table to your excel sheet.

This slideshow requires JavaScript.

In the same way, we can also import the other data sources to Microsoft Excel. Hope it helps. Happy learning!!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s