Problems with Append Query

[LebronJames]

When I use an append query on a table of 1000 records, the new fields are added ok. When I use the same append query in table of 300000. Not all the records are brought over. I am using Access 2000. Is there an option in Access that allows me to change the Deafult Max records. Or can I program this in code?

Here is the query I am using:

INSERT INTO Table1
SELECT *
FROM Table2
WHERE (((Table1.field1) Not In (select Field1 from Table1)));

 

[PHV]

WHERE (((Table1.field1) Not In (select Field1 from Table1)));
You really use this criteria ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[PHV]

You may try something like this:
INSERT INTO Table1
SELECT Table2.*
FROM Table2 LEFT JOIN Table1 ON Table2.field1=Table1.field1
WHERE Table1.field1 Is Null;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[LebronJames]

Problem is the unique field is blank or null... removed the blank or null value and append worked....