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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2003 Michael Kofler
About this chapter
Cite this chapter
Kofler, M. (2003). Access to External Data. In: Definitive Guide to Excel VBA. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-0666-8_12
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0666-8_12
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-59059-103-1
Online ISBN: 978-1-4302-0666-8
eBook Packages: Springer Book Archive