Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
 Import data from Excel to a new table in Access 
 
  Overview  
 Show/Hide lesson sections Import data
  Feedback  
 Quick Reference Card Quick Reference Card  
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.
Bookmark and ShareShare
Overview
Learn how to import data  

Learn how to import data from Excel into a new table in Access. Importing is a simple way to put Access to work for you.

Don’t have the 2007 Office release? You can download a free 60-day trial or buy it now.

  • Length: 35–40 minutes
  

Next

GOALS

After completing this course you will be able to:

  • Prepare your data in Excel so that it imports successfully.
  • Import data from an Excel worksheet into a new table in Access.
  • Check your imported data for accuracy.
  
ABOUT THIS COURSE

This course includes:

  • One self-paced lesson and one practice session for hands-on experience. The practice requires Access 2007 and Excel 2007.
  • 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.
AUDIO TEXT

Have you ever needed a quick way to move data from Excel to Access? You can do it by importing data from your worksheets into a new table.

This course shows you how to prepare your Excel data for import, how to use the import wizard in Access to import data into a new table, and how to check your results for accuracy.

To learn more about this course, read the text in Goals and About this course, or look at the table of contents. Then click Next to start the first lesson.

  
BEFORE YOU BEGIN

If you're new to Access, complete the course listed below before you take this course.
  Go to previous page (disabled)    Next Go to next page
advertisement