Questions regarding importing and merging data

[Sandy Modesitt]

Hello,
I really have 2 questions:

1) Why can't I directly import data into tables in Access 2000? We have 2
copies of a database and I want to import the data from one directly into
the table in the other. The best that I can do is import the table (data
and format which then creates a new table with '1' at the end) and then copy
the records from the newly created table. This could also be achieved by
opening both databases and copying/pasting the records. I thought that I
remembered importing records into a table in the past but I must be
mistaken.

2) The other question involves a problem importing records (i.e. copying the
records as described above) that have one or more decimal fields in the
table. They import OK if there are no duplicates, but if there is a
duplicate, I get the "duplicates" error message and then, instead of it
putting the duplicates into a "Paste Errors" table (and providing a message
to that effect), I receive the following error "Invalid precision for
decimal data type". I have verified that the 2 tables have identical
settings for the decimal fields. I also changed them both from decimal to
Long Integers and the problem goes away. Any ideas? I can't find anything
on Microsoft's Knowledge Base and have even tried a Google search to no
avail.

Thanks.
Sandy

 

[tina]

to transfer data from a table in one db to a table in another db: rather
than importing the table object, or opening both dbs and doing a copy paste
of records, suggest you just link the table-that-has-data into the
db-that-has-table-that-needs-data. then use an append query to dump the
records from the has-data table into the needs-data table. if the field data
types are identical, it shouldn't be a problem.
however, if you are getting the "duplicates" error, then you probably have a
primary key or unique index set in the needs-data table, that *is not set*
in the has-data table. to get a complete records dump, you'll have to find
and remove that.

hth