Append Query - Invalid Argument message

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to run append queries to join 8 tables. I was able to run the
query one time, however, each time after I receive the following message:

"Invaid Argument"

All of my tables are identical...any help would be great!

Thanks :)
 
Hi,

Not enough info to answer, however, this could be because there are
duplicate primary key values in the tables - that is the target table and the
source table.
 
I do not have any primary keys set. What kind of information do you need. I
am new at this and do not know what type of information you need.

Thanks.
 
Jande30 / Shane

I too have exactly the same problem...i am trying to append data in table A
to table B ( both tables are identical in structure and have no primary key ).

However I am getting the error message ( INVALID ARGUMENT ) ....

plz any suggestions ?

rgds
SCM FREAK
 
Posting some SQL might be helpful

Pieter

scmwiz said:
Jande30 / Shane

I too have exactly the same problem...i am trying to append data in table
A
to table B ( both tables are identical in structure and have no primary
key ).

However I am getting the error message ( INVALID ARGUMENT ) ....

plz any suggestions ?

rgds
SCM FREAK
Click to expand...
 
Hi,

Are you doing this with VBA or SQL or just on the query grid? If you have
criteria what are they an under what field?
 
Back
Top