O'Reilly logo

Microsoft® Office Access™ 2007 Plain & Simple by Curtis D. Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Importing Data from an Excel File

On the surface, Excel and Access look a lot alike. Both programs handle data lists effectively. In fact, some small-business owners maintain all of their data lists in Excel and use that program’s summary functions, sorting, and filtering capabilities as if Excel were a database program. That’s fine if you have a single data table you want to analyze, but there’s no easy way to create relationships between tables, define queries using filters, or generate reports. Fortunately, there’s a straightforward process you can follow to bring an Excel data list into Access. Once your Excel data is in a database, you can create reports and queries that are possible, but very hard, to create in Excel.

Import Excel Data

  1. Click ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required