Abstract
One of the most prominent features of Access is its ability link or import external data sources. In addition to its own internal tables, it can link to many other types of databases. In the early days of Access, this was accomplished primarily through Open Database Connectivity (ODBC) data sources. Access can still link to any data source that you can obtain an ODBC driver for. This includes SQL Server, Oracle, MySQL, DB2 and more. Access 2010 can also link to Outlook and SharePoint.
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
© 2011 Mark Collins
About this chapter
Cite this chapter
Collins, M. (2011). Using External Data. In: Pro Access 2010 Development. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-3579-8_17
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3579-8_17
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-3578-1
Online ISBN: 978-1-4302-3579-8
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)