Access Imports and Exports

You can copy information from an Excel worksheet and paste it into an Access datasheet, and vice versa. However, to convert longer lists of data, an import or export operation might be more appropriate. To perform an import or export, use the External Data tab on the Ribbon in Access (Figure 42-14).

Figure 42-14. Click a choice on the External data tab to start an Access import or export.

[View full size image]

If you are exporting information, open the table or query with the data to export. Then, after clicking the External Data tab, you can click a button in the Import or Export group on the tab to display the Import or Export (Figure 42-14) dialog box. Make the needed choices in the dialog box and then click OK to perform the import or export.