Microsoft® Excel® 2010 Inside Out

Opening an Entire Access Table in Excel

To import an entire table created in Access (as opposed to a specific set of records from that table), click the Data tab, and then click From Access in the Get External Data group. Windows launches a search for files with the extensions .mdb, .mde, .accdb, and .accde. When you find the Access file you’re looking for, select it, and then click Open. If your database has more than one table, you’re presented with the Select Table dialog box, which is shown in Figure 24-4. (Drag the lower-right corner of the Select Table dialog box if you need to see more of the Description column.)

Note

For information about importing selected records from an Access (or other) database using Microsoft Query, see Using Microsoft ...