Table Import (*.xlsx)


This tool enables you to create a table based on a sheet from an Excel (*.xlsx) File.
To Create a Table:


Start the too 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


  1. Click the down arrow in the Choose an Excel Data Link dropdown.
  2. Select an existing link.
  3. Click the Delete button.