Versions Compared

Old Version 5

changes.mady.by.user user-5d3f2

Saved on

compared with

New Version 6

changes.mady.by.user user-5d3f2

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

...

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.