Page 643 - Excel 2013 All-in-One For Dummies

✦ New Worksheet option button to have the data in the Access data table(s) imported into new sheet(s) that’s added to the end of the sheets already in the workbook.
✦ Add This Data to the Data Model check box to add the imported data in the Access data table(s) to the Data Model already defined in the Excel workbook using relatable, key fields.
✦ Properties drop-down button to open the drop-down menu with the Import Relationships Between Tables check box (selected by default) and Properties item. Deselect the check box to prevent Excel from rec- ognizing the relationship established between the data tables in Access. Click the Properties button to open the Connection Properties dialog box, where you can modify all sorts of connection properties, including when the Access data’s refreshed in the Excel worksheet and how the connection is made.
Figure 2-9 shows you an Excel Customers worksheet after importing both the Customers and Orders data tables from the sample Northwind Access database as new data tables in a new Excel workbook. When I imported the two data tables, Excel automatically added two new worksheets (Sheet2 and Sheet3) to the workbook, while at the same time importing the Customers data table to Sheet2 (which I renamed Customers) and the Orders data table to Sheet3 (renamed Orders). I then deleted Sheet1 (which was blank) prior to taking the screenshot for Figure 2-9.
External Data Query 625
Figure 2-9:
Customers worksheet with the data imported from the Customers data table in the Northwind database.
Book VI Chapter 2
Filtering and Querying a Data List