Merge two tables??

[Megan]

Hello,

I am trying to merge two tables together. I have done it
many times before by creating a new table and coping the
data from each table into it. (Both tables are excately
the same; the user managed to make a copy of the database
and had been using both databases to enter information.)
From there I use a SELECT DISTINCT query to flush out all
the duplicates.

The problem this time is that even though the tables have
excately the same properties, I am getting two error
messages. One says that the input mask does not allow
dadta of this type. (I removed all input masks from the
data and converted all data types to text and I still get
the message.) The other error message is that the data is
too long to be inserted. Try and insert smaller data. I
don't even know what that message is complaining about.

I wonder if the problem is something that occured because
the database was converted from 97 to 2002.....Any help
greatly appreciated.

 

[John Vinson]

The problem this time is that even though the tables have
excately the same properties, I am getting two error
messages. One says that the input mask does not allow
dadta of this type. (I removed all input masks from the
data and converted all data types to text and I still get
the message.) The other error message is that the data is
too long to be inserted. Try and insert smaller data. I

I wonder if you have some Lookup fields in play here. If so, you may
be attempting to copy text into a (hidden) numeric field.

Rather than copy and paste, I'd suggest putting a unique index on the
field (or combination of fields) that uniquely identify a record, and
then running an Append query to append the records from one table into
the other.