Import Excel Worksheets

An option has been added to the ribbon to support loading worksheets from an Excel Workbook into LANSA tables.

It is only available where the appropriate driver to support Excel 12.0 is installed. A message will be issued if you select this option without the appropriate driver installed.

• 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 with the data from the Excel worksheet.

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

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