Appending records to source and destination tables

G

Guest

Hi Folks,

Can you please help -I'm running an append query with a problem. Here's
the SQL in the query:

INSERT INTO Transactions ( ItemNo, DateConsumed, LogOutBy, ItemDescription,
LogQty )
SELECT History.ItemNo, History.DateConsumed, History.LogOutBy,
History.ItemDescription, History.LogQty
FROM History
WITH OWNERACCESS OPTION;

The problem is, it appends the whole table to the source table before it
appends the whole thing to the target table. Can you tell me what I'm doing
wrong. I know this is a simple task I just don't see what's wrong.

Thanks.
 
G

Guest

I got it - as usually happens when you ask a question - you keep hacking and
get it. I had copied the table to a new table (right click, save as) and for
some reason this made that happen. When I deleted it manually made the table
and relinked it I stopped having the problem.
 

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 new records to a table with a compound primary key 9
Large Union Queries and Appending the data 1
Access 2007 - append query only appending 0 rows??? 0
Append query with an Inner Join to Destination Table Not working 2
Only first few records visible in table after running append query 1
Append only new records to a table 2
Append Query - key violation - no duplicates, records exist in par 4
Append many queries to tables 1

Top