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

Using CopyFromRecordset

This chapter focuses on using the ADO and DAO object libraries to bring data from a database into an Excel workbook. Most of the material concerns fine-tuned activities, such as using VBA code to find the exact location that data needs to occupy on a worksheet. Often, though, you're less interested in picking and choosing among records and putting a field value in a particular location, and more interested in copying a lot of data very rapidly.

You could use an external data range, if you wanted to, as described in Chapters 4, “Importing Data: An Overview,” and 5, “Using Microsoft Query.” Refreshing an existing data source is a speedy process. But you usually set up an external data range manually, starting with Data, Import External Data. (You can set one up using VBA, of course. To see how this is accomplished, just turn on the macro recorder before you start the process.)


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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