"invalid argument' error when appending two tables

[Guest]

I continue to get an 'Invalid Argument' error when I try to append two
tables. I have re-created the tables multiple times to make sure they are
identical, and I still get the error message. Each table has the same number
of columns and the field names are the same in each of the tables. Any ideas
on what the problem might be? I have even checked to make sure the
properties of each field are the same; and they are.

 

[Guest]

Just a thought - may not be the case - do both tables have autonumber id
fields. Are you trying to append a number from one table into the autonumber
of the other.

 

[Guest]

Niether one contains auto numbers or a primary key.

 

[Guest]

You could test the whole thng maually.

Open one table and select all records. Copy.

Paste append into table 2 and see what happens.

Or

Run a make table query based on both tables

Or bring both tables into a select query and (again) see what happens.

etc
etc
etc

I can't see your DB so not much else I can suggest

You could try append (use an append query) one field at a time from table
one nto table 2 - you got it - see what happen.

DO ALL THIS ON A COPY OR BACKUP - just in case

 

[Guest]

I get the same error when I try everything that you mentioned. I would say
there might be something wrong with the original Excel file, however, a
co-worker of mine is using the same file and she is able to everything that I
am not able to do.

 

[Guest]

You didn't mention excel before