Share this Page URL

Chapter 4. Importing and Linking to Data > Importing Data - Pg. 109

Importing and Linking to Data 109 Quick Check Q. What are two reasons to import data rather than to link to it? A. You are converting the data from its original format, and you want the best performance. Q. Can you import data of one type into a field of another type? A. No. The data you import needs to match the data type of the field you're importing it into. Importing Data To import data into an Access database, open the database, and click File, Get External Data, Import. You'll see the Import dialog box, shown in Figure 4-1. Figure 4-1. The Access Import dialog box. The Files Of Type list displays the data formats that you can import into Access Open the Files Of Type list, and you'll see the data formats that you can import into Access. Here's the list: · Microsoft Access database. · Microsoft Access project (.adp files). (We'll cover Access projects in detail in Chapter 14, "Un- derstanding Access Projects.") · dBASE and Paradox databases, Microsoft Excel spreadsheets, and Lotus 1-2-3 spreadsheets. · Microsoft Exchange and Microsoft Outlook items. · Microsoft SharePoint Team Services. (We'll cover how Access and SharePoint work together in Chapter 15, "Integration with Office 2003 and SharePoint Services.") · Text files. · HTML documents.