Import Data Into Excel – SQL Server Import and Export Wizard
October 11, 2010 4 Comments
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.
- Choose SQL Server Native Client 10.0 in Data source.
- Enter (local) in Server name.
- Select AdventureWorks in Database.
- Click Next > button.
- Select Microsoft Excel in Destination.
- Enter C:\Users\Andrew\Documents\demo.xls in Excel file path.
- Click Next > button.
- Click Next > button.
- Select all [HumanResources] prefix tables.
- Click Next > button.
- Click Next > button.
- Click Next > button.
- Click Finish button.
- Click Close button.
If we open the Excel workbook, you would see there are 7 worksheets; each corresponds to one sources table from SQL Server.
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.
- Import Data Into Excel – VBA
- Import Data Into Excel – Data Connection
- Import Data Into Excel – SQL Server Import and Export Wizard
Andrew Chan is the owner and founder of ALG Inc.
We help you to make better and faster decisions!
About Andrew Chan
Go Beyond Excel 
Pingback: Import Data Into Excel – XML « Technologies and your business
Pingback: Import Data Into Excel – Data Connection « Technologies and your business
Pingback: Import Data Into Excel – VBA « Technologies and your business
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