Microsoft® Office Excel® 2007 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 Vista will launch 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. You’ll be presented with the Select Table dialog box, which is shown in Figure 23-4. (Drag the lower-right corner of the Select Table dialog box if you need to see more of the Description column.)

Figure 23-4. When you click the From Access command to open ...