4.5 Import Excel Worksheets

Use Import Excel Worksheets to load worksheets from an Excel Workbook into LANSA tables.

This feature is only available on machines that have the appropriate driver to support for Excel 12.0 installed. See 4.5.1 Installing the Driver.

• To import a worksheet, select Import Excel Worksheets from the Tools tab on the ribbon:
  
  
  
  

• Choose the file to be imported.
  
  
  
  

• Select the worksheets to be loaded as LANSA tables:
  
  
  
  

• Verify the selected work sheets and columns which will be generated:
  
  
  
  

Each work sheet generates a LANSA table, the name/identifier/description of the table needs to be provided. You can select to include all or a subset of the columns from the original worksheet definition.

After the tables are generated and compiled, data will be copied into LANSA tables corresponding to the data from the Excel worksheet.

• Verify the table(s) have been created with the expected columns and data copied into them: 

Temporary tables created during the import are automatically removed upon completion of the processing.