Import Layouts are created to automatically map column header from any file to be imported with the column headings in the database.

Single File Import
The Single File Import form imports an individual file to append or merge data into the selected table.

Multifile File Import
The Multi File Import option is used for regular file import of files with preformatted layouts.

• Supported formats: Excel, CSV, fixed width Text files (SIF), Datamine text, Micromine text.
• Import any supported file format and manually or automatically match to tables and fields in the database.
• Create import layouts to automatically match and load files with headers different to those in the database tables.
• Define SQL statements and VBA routines to manipulate and validate data on import.
• Batch loading or Multi File importing for unlimited numbers of files.