Chapter 17. Using External Data
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.
In previous chapters, I have already demonstrated linking to other Access and SQL Server databases. In this chapter, I will demonstrate how to link to Outlook and SharePoint. I will also show you how to import an XML file. This is not ...
Get Pro Access 2010 Development now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.