Choose specific data
When you import or link to data from the following programs, you must also select specific data within the source file. You are prompted to select specific data after you have selected the source file in the Import Data Wizard, Link Data Wizard, Import Territories Wizard, or Link Territories Wizard.
Microsoft Excel
Data from Microsoft Excel files (*.xlsx; *.xls; *.xlt) can consist of multiple sheets or named ranges.
Select the sheet or named range that contains the data you want to import or link.
Click Next to continue the import or link process.
Microsoft Outlook
Data from Microsoft Outlook consist of contacts within a folder.
Select the Contacts folder you want to import or link.
Click Next to continue the import or link process.
Note You cannot create territories using the Contacts folder in Outlook.
Microsoft Access
Data from Microsoft Access files (*.accdb; *.mdb; *.mdw; *.mda) consist of tables or queries.
Select the table or query that contains the data you want to import or link.
Click Next to continue the import or link process.
Another database, using Microsoft Data Link
Data from databases that support Microsoft Data Link (*.udl) consist of tables or views.
Select the table or query that contains the data you want to import or link.
Click Next to continue the import or link process.