Append Table problem

Hi all,

I am having a problem appending data to an existing table. I have two
tables with identical fields and I want to append the data from one
table (T2) to the first (T1). T1 has 136 records and T2 has 209, for
a difference of 73 records. When I run the append query, only 72
records are selected from T2, and there doesn't seem to be a pattern
as to why the records selected were selected. They aren't the last 72
records or the first. Can anyone tell me what I am doing wrong or if
they have had this happen before.

Thanks,

Wade
.

Relevant Pages

  • Re: Append Table problem
    ... I am having a problem appending data to an existing table. ... tables with identical fields and I want to append the data from one ... When I run the append query, ... and there doesn't seem to be a pattern ...
    (comp.databases.ms-access)
  • Re: Append only first instance with sed?
    ... > append the first time the pattern is found. ... Ed rewrites the original file, ... sed -f file inputfile> outputfile ...
    (comp.unix.shell)
  • Re: Append Table problem
    ... tables with identical fields and I want to append the data from one ... When I run the append query, ... with duplicates being okay. ...
    (comp.databases.ms-access)
  • Re: array names and brackets
    ... the command line and b) are special to the glob pattern ... set foo "helpme" ... or use append to build your final string in pieces, ...
    (comp.lang.tcl)
  • Re: advice on how to search for a string in line
    ... You seem to be searching for some pattern "aaa_" and then printing the line containing that pattern plus the Nth line after it twice, and dropping every other line in the file. ... If you truly want to append the Nth line to your pattern line and print just that resulting string twice then this should do it: ...
    (comp.lang.awk)