Appending tables in Access
<p>I have 2 large datasets of over 800k rows which I would like to merge into a single table in Access. Thus, I'm using an Append-type of query in Access, but I get an error message saying that it didn't add the rows because of key violations.
The SQL query is the following:</p>

<pre><code>INSERT INTO table_name_A
SELECT [table_name_B].*,*
FROM table_name_B
</code></pre>

<p>Any hint on why I get the error message?</p>