This tool enables you to create a table based on a sheet from an Excel (*.xlsx) File.
To Create a Table:
- Start the tool and the dialog appears.
- Click the down arrow in the Choose an Excel Data Link dropdown.
- Click on Create New Data Link.
- Type in a name and click OK.
- Click the down arrow in the Choose an Excel file dropdown.
- Click on Browse for a new Excel (*xslx) file.
- Select a file.
- Click Open.
- Click the down arrow in the Select Excel sheet to link to dropdown..
- Select a sheet.
- Click OK.
- Position the cursor and click to insert the table.
- The dialog will reopen.
- Change the parameters and insert another sheet, or click Cancel to terminate the operation.
To Delete a Data Link
- Click the down arrow in the Choose an Excel Data Link dropdown.
- Select an existing link.
- Click the Delete button.