Download View PDF Documentation

E142: The output table exists but does not contain any of fields defined in the model, nothing
imported.
Import Wizard does not modify exiting tables. If none of the fields defined in the model are present in the output
table then the import fails. Rename the fields in the model or set the Set Table Action to 'create table' to create
the table.
E143: Record Action Error: 'Update' specified but without any Update Key fields, either select Insert
as import action or set the Update Key field property for at least one field.
When the 'Update' or 'First Update then Insert' record action is used you should set the Update Key property for
at least one field to True.
E144: Update Record Action specified but update key field '%1%' is missing in the output table.
Either select Insert as import action or unset the Update Key field property for this field.
All Update Key fields are required to exist in the output table to guarantee correct updates. Either remove the
indicated field from the model or add it to the output table.
Source File Warnings
W201: Source file '<Filename>' not found.
Upon trying to import using the model Import Wizard couldn’t find the source file. Supply the correct file name.
W202: Error while opening file '<Filename>'. <Error Description>
An error occured upon opening the file. See error description for details
W203: Could not open import range '<Rangename>' in input Excel file '<Filename>'.
The Range could not be found in the Excel source file.
Output Warnings
W221: Error while appending record. Field Name='<Fieldname>' Value='<Field Value>'
Error=<Error Description>
A general error occurred while attempting to append (insert or update) a record to the destination table, the
record is not appended.
W222: Record insert failed. <Error Description>
An error occured while inserting a record in the output table. See error description for details.
W223: Record update failed. <Error Description>
An error occured while updating a record in the output table. See error description for details.
W224: Failed to delete existing records from output table '<Table Name>'. <Error Description>
The output table contains records and you specified 'Empty' as Table Action, Import Wizard failed to delete the
records from the table.
Action: in the output set the Table Action to 'Append' or 'Create'.
W225: Table Action Error: 'Create' specified but unable to drop (delete) the existing output table
failed, using existing table.
The Import Action was set to 'Create' but the existing table could not be dropped (deleted). The existing table is
used for the import.
W226: Error while closing output Excel file. <Error Description>
An error occured upon closing the output Excel file. See error description for details.
W227: Error executing SQL statement. <Error Description> SQL=<SQL>
An error occured executing the pre- or post-import SQL statement(s). See error description for details.
Field Warnings
W241: Field '<Field Name>' not found in output table, field ignored.
The output table exists but does not contain the <Field Name> field. Imports to this field will be ignored.
Action: Import Wizard does not modify existing tables, either modify the destination table in your database to
include the field or set Table Action to 'Create' to create a new table.
W242: Unable to create field '<fieldname>'.
The field could not be created. Check for illegal characters in the fieldname.