O'Reilly logo

Pro Access 2010 Development by Mark Collins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required