Append truncates some text fields

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

When I append a text field from a staging (temp) table to the master table,
some, but not all, of the data is truncated by 1 character.

The field definition is identical in both tables:
Data type = Text
Field size = 9
Required = No
Allow Zero Length = No
Except only the index. The field is not indexed in the staging table. It is
indexed (allow duplicates = Yes) in the master table.

The data in the field is a string of 9 digits (I use text because some of
them begin with 1 or more zeros.) The append query is a straight append with
no transformations on this field.

The staging table has 7025 records. I have confirmed that the data in this
field for all records in the staging table is exactly 9 digits. However,
after appending these records to the master table, 1391 of the records have
only 8 digits in this field (the right most digit has been dropped.) All the
rest have the correct 9 digits.

Does anyone have a suggestion as to what might be causing this apparently
random truncation?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200610/1

.

Relevant Pages

  • Re: Append truncates some text fields
    ... I would check the Format and Input Mask properties. ... The field is not indexed in the staging table. ... The append query is a straight append ... field for all records in the staging table is exactly 9 digits. ...
    (microsoft.public.access.queries)
  • RE: Multi user database
    ... I need to append new ... the other user updates table c then run the append query. ... Right now I can determine when the master table is updated, ... the database they should 'share' the data not update to/from local copies. ...
    (microsoft.public.access.modulesdaovba)
  • Re: union 120 tables in Access (easy way?)
    ... The simplest method would be to choose one table as the master and then append the remaining 119 tables into the master table. ... If there are just 120 tables, then it should be possible to write some VBA that would loop through the tables and append them all to one master table. ... Dim DbAny as DAO.Database ... Dim tdef as TableDef ...
    (microsoft.public.access.queries)
  • Re: loop thru records to create a union query
    ... master table and somehow populate that field with the names of the ... You could use a query like ... I would just build the 150 append queries one time and run them all ... I wouldn't build a Union query with it though - ...
    (microsoft.public.access.modulesdaovba)
  • Re: Grid on a form
    ... After I append the ss field from the master to the daughter.field, ... > Hi John, ... One of the pages keeps track of students general ...
    (microsoft.public.fox.vfp.forms)