Page 1 of 12PREVNEXT

Import data: Import external data into Excel 2003

Import external data into Excel
Learn to import data that is stored in a database into Microsoft Office Excel by using the Data Connection Wizard.

About this course

This course includes:

  • One self-paced lesson and one practice session for hands-on experience.
  • A short test at the end of the lesson; the test is not scored.
  • A Quick Reference Card you can take away from the course.


After completing this course you will be able to:

  • Use the Data Connection Wizard to import external data that's stored locally on your hard drive or on a server.
  • Reuse the Office Data Connection (.odc) files that connect to your external data sources.

Before you begin

To learn about other ways to import external data, see the following courses:

External data is data that is stored outside of Excel, in databases created in Microsoft Office Access, Microsoft SQL Serverâ„¢, or on a Web server, for example. Whether that data is in a database stored on your computer or on a remote server, it's a snap to import it into Excel.

Once you have the data in Excel, there are all sorts of ways you can analyze it. You can use AutoFilter to see just the data you need to see, create PivotTable reports to organize and summarize your data to reveal its meanings, or use charts to create pictures out of the data.

And if the information in the external data changes, you can refresh the data in Excel to keep it up to date.

To learn more about this course, read the overview in the center of this page or the table of contents in the left column. Then click Next to start the first lesson.

Page 1 of 12PREVNEXT