11 Sharing Data with Other Applications
One of the strengths of Access 2010 is its ability to share data with other applications.
Microsoft Access is very capable of interfacing with data from other sources. It can use data from any OLE DB or ODBC (Open Database Connectivity) data source, as well as data from FoxPro, dBASE, Paradox, Lotus, Excel, and many other sources. In this chapter, you will learn how to interface with other Access databases, Excel, ASCII text files, and ODBC data sources.
What Is External Data?
External data is data that is stored outside the current database. External data may be data that you store in another Microsoft Access database, or it might be data that you store in a multitude of other file formats—including ISAM ...
Get Using Microsoft® Access® 2010 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.
