Database connections and import templates are created in Metrics Management and typically do not require the assistance of a DBA or of IT resources. To create a connection to Excel, perform the following tasks:
Define a named range in the Excel file.
Create a connection to the Excel file.
Create and configure a Metrics Management export or import that uses the connection.
To export to Excel, the system specialist defines a single row for the named range and exports into that named range. During the export, the number of rows changes dynamically as the export progresses.
To import data from Excel, the named range must encompass all of the data to import.
Define a named range in the Excel file.