Chapter 7. Importing, Linking, and Exporting Using External Data Sources

In Chapter 5, I covered the basics of using ADO and SQL to work with data sources. All the ADO and SQL examples dealt with data stored in tables in a database. However, in today's world of technology, you often work with data and applications in a variety of formats, such as text files and spreadsheets. You may need to import or link data from various sources into your database to avoid having to retype all the information that is already stored electronically in another format. At some point, another application might need the data in your application or you may want to get data out of your application for another reason. In that case, you can export information from your application into another format.

In this chapter, I will explore the various ways to use VBA code to link, import, and export to external data sources. The chapter will cover:

  • The difference between linking, importing, and exporting

  • Linking, importing, and exporting to external Access databases (MDB files)

  • Linking, importing, and exporting to SQL Server databases

  • Linking, importing, and exporting to other files such as spreadsheets and text files

  • Creating and sending an e-mail programmatically

  • The definition of a Web service and how you can use data returned from a Web service

These techniques will enable you to build robust applications that interact with a various applications and formats.

Linking, Importing, and Exporting Overview

Linking to external ...

Get Beginning Access 2003 VBA 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.