Microsoft Office Tutorials and References
In Depth Information
Importing, Exporting, and Connecting to Data Sources
After you click Finish, the wizard allows you to choose an alternate location for the data
import. Click OK to complete the import.
By default, when you import data, Excel creates a persistent connection to the data file. For
some operations, that’s a great time-saver. If your corporate database spits out an updated
version of a text file every day in a consistent location, you can click Refresh All in the
Connections group on the Data tab to add the most recent data to the table you’ve imported.
Likewise, you can use Access forms to keep a database up to date and then perform
analysis on the most recent version of the data in Excel.
But what if you intended for the import to be a one-time operation? In that case, click in
the imported table or range, and then click Connections in the Connections group on the
Data tab. That opens the Workbook Connections dialog box shown in Figure 12-17. Select
the connection you just created, and click Remove to break it.
Export operations are far simpler. Click any cell in the database range or table—or select a
specific range if you want to export only a portion of the data. Then click File, click Save As,
and choose the appropriate format. If you pick CSV (Comma Delimited), you can count on
the data being usable with any other data-management tool.
For tables, you’ll find an Export option on the Design tab under Table Tools. This menu allows
you to save your data as a SharePoint list. For details, see “Creating, Viewing, and Editing
SharePoint Lists” on page 873.