Appending Overwriting, instead of appending

A

Anne

I can't figure this one out - an append query is overwriting the first record
in the table, instead of appending it to the end.

Please help - thank.
 
J

Jerry Whittle

There's only one practical way for us to know: Show us the SQL. Open the
query in design view. Next go to View, SQL View and copy and past it here.
Information on primary keys and relationships would be a nice touch too. Also
any indexes.
 
J

Jerry Whittle

Another thought: Are you sure that it's overwriting the first record in the
table OR it's just showing up first when you open the table? What is the
primary key field for the table? That's how you can tell.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Appending an existing table with imported Excel data 0
Append Crosstab Query to Existing Table 0
Data changes in append query 1
Append Query 7
Appending to a data record 1
How to append running number 2
check while appending data 5
Append query without duplicate rows 5

Top