• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 11. Getting Data from Access and... > Bringing Data Back from a Parameteri...

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint