Microsoft Office® Access 2007 Inside Out

Chapter 6. Importing and Linking Data

A Word About Open Database Connectivity (ODBC)

Creating a Data Source to Link to an ODBC Database

Importing vs. Linking Database Files

Importing Data and Databases

Importing Spreadsheet Data

Importing Text Files

Modifying Imported Tables

Linking Files

Collecting Data via E-Mail

You can certainly build all your tables, design queries, forms, and reports, and then enter from scratch all the data into your empty tables. However, in many cases you’ll have some of the data you need lying around in other files. For example, you might have a customer list in a spreadsheet or a text file. Your list of products might be in another non-Access database file. Microsoft Office Access 2007 provides tools to help you bring ...