Importing and Linking Data

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, but your list of products might be in another non-Access database file. Microsoft Access 2010 provides tools to help you bring the data into your new application.

Although you can use Access 2010 as a self-contained database and application system, one of its primary strengths is that it allows you to work with many kinds of data in other databases, in spreadsheets, in text files, or in Microsoft SharePoint lists. In addition to using data in your local Access 2010 database, you can import (copy in) or link (connect to) data that's in text files, spreadsheets, other Access databases, dBASE, Microsoft SharePoint lists, and any other SQL database that supports the Open Database Connectivity (ODBC) software standard.