The Field Is Too Small To Accept The Amount Of Data You Attempted To Add

When I import data from another file format i.e. Mid/Mif file or Shape file, you get this error:

The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data’. ‘WktLayer.:InsertWktGeometry Failed to Save Geometry.SQL = SELECT*FROM edit_layer WHERE 1=2

This is because the text data in the file that you are trying to import is longer than 50 characters, which means it cannot be imported into the Edit Layer without increasing the size of the label field in the edit_table (where the attribute data is imported). To fix this:

  1. Open C:\Program Files\QMap\Data\custom.mdb and modify the design of the edit layer (edit_layer) to make the label field a memo field.
  2. QuickMap Version 7 or better will automatically adjust the field size if possible.

Comments are closed.