Advertisement

Access to External Data

  • Michael Kofler

Abstract

In this chapter we discuss how to access data stored in an external database system from within Excel. There are essentially two ways to accomplish this: One is to use the wizard provided for this purpose, which in turn calls the program MS Query. (This form of data importation can be controlled via the QueryTable object.) The alternative is to use the new ADO library, which provides a host of objects for reading and editing data.

Keywords

Data Record Access Database External Data Character String Excel File 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Michael Kofler 2003

Authors and Affiliations

  • Michael Kofler

There are no affiliations available

Personalised recommendations