Managing Data with Microsoft® Excel

Bringing Data Back from a Parameterized Query

This section walks you through the process of populating a worksheet with data returned from a database using a parameterized query.

Setting the Layout Requirements

The layout and appearance of the worksheet are important for the room scheduling purposes described earlier. The data must be put in specific cell ranges. That's the reason that the code resorts to recordsets: It's insufficient to merely return records from the database by choosing, for example, Import External Data from the Data menu. That approach imports data as a list, but the layout that's required is as shown in Figure 11.1.

Figure 11.1. Names of meeting rooms are shown in column A, and times are shown in row 1 in 15-minute increments. ...