19. Sharing Data with Other Applications
In This Chapter
• What is external data, and why do you care?
• What does it mean to import data versus link to data, and when should you use each?
• How can you export access data?
• How can you import data into Access?
• How do you link to data in other Access databases?
• How do you link to data stored in Microsoft SQL Server?
Microsoft Access can interface with data from other sources. It can use data from any OLE DB or Open Database Connectivity (ODBC) data source and data from FoxPro, dBASE, Paradox, Lotus, Excel, and many other sources. In this chapter, you learn how to interface with other Access databases, Excel, ASCII text files, and ODBC data sources.
What Is External Data?
External data ...
Get Access® 2013 Absolute Beginner’s Guide 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.
