Import Data Into Excel – SQL Server Import and Export Wizard

I discussed how to use SQL Server Import and Export Wizard to import data from Excel in my previous blog.  Someone asked me if they would use the same tool to import data into Excel.  Of course, it can.  I frequently use it because it can import and export data from many different data sources, e.g. Access, Oracle, SQL Server, text files and of course Excel.

If you don’t have it, you can download the free SQL Express from Microsoft.  I have another blog described how to install it.  Once you installed it, you can import data into Excel with a few mouse clicks, without any programming at all.

Import Data Into Excel

  • On the Start menu, point to All Programs, point to Microsoft SQL Server 2008 R2, and then click Import and Export Data.

image

  • Choose SQL Server Native Client 10.0 in Data source.
  • Enter (local) in Server name.
  • Select AdventureWorks in Database.
  • Click Next > button.

image

  • Select Microsoft Excel in Destination.
  • Enter C:\Users\Andrew\Documents\demo.xls in Excel file path.
  • Click Next > button.

image

  • Click Next > button.

image

  • Select all [HumanResources] prefix tables.
  • Click Next > button.

image

  • Click Next > button.

image

  • Click Next > button.

image

  • Click Finish button.

image

  • Click Close button.

image

If we open the Excel workbook, you would see there are 7 worksheets; each corresponds to one sources table from SQL Server.

image

Conclusion

We don’t need to know programming because we didn’t write a single line of code.  We can save the package for future use.  It is quick to develop and it is also very flexible; we can import as many tables as we want.  We didn’t go into details but if we are familiar with SQL statement, then we can select what records or columns to be transferred from SQL Server to Excel.  And we can use the same tool to transfer data from Oracle to Access, from Access to Excel… etc.  SQL Server Import and Export Wizard is a very powerful, flexible, and easy to use end user tool.

Andrew Chan is the owner and founder of ALG Inc.

We help you to make better and faster decisions!

About Andrew Chan
Andrew Chan is an Business Consultant who gives you accurate, consistent and timely information so that you can make better and faster decisions. He is an Associate of Society of Actuaries with over 20 years of IT experience. Apart from strong analytical skills and proven technical background, he was also a former system director at Manulife who had extensive project management experience. If you are looking for someone to gather, consolidate, validate, visualize and analyze data, look no further! Andrew can provide the most cost effective business analytics solution so that you can explore, optimize, predict and visualize your business. Don’t guess on any decision, no matter it is finance, operation, marketing or sales! Always ask for evidence!

4 Responses to Import Data Into Excel – SQL Server Import and Export Wizard

  1. Pingback: Import Data Into Excel – XML « Technologies and your business

  2. Pingback: Import Data Into Excel – Data Connection « Technologies and your business

  3. Pingback: Import Data Into Excel – VBA « Technologies and your business

  4. Ali says:

    SQL Server Import and Export Wizard

    SQL Server Import and Export Wizard The SQL Server Import and Export Wizard is the easiest utility to work with. Its interactive GUI provides a simple interface to build and run Integration Services packages. You have already used this tool […]

    for more visit us
    http://server2008.org/?p=888

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

%d bloggers like this: