Copying and Pasting Data between databases

M

Marc

fI have a situation where I have two exactly identical databases except for
the data in each one. All of the formatting is completely the same. A new
database had been started in order to create updated information, and now I'm
trying to copy the updated data into the previous database.

The problem is, the old database keeps telling me that my format isn't
correct, or the fields are too small. Is there away to fix this?
 
M

Mr B

Marc,

Why not just link to the table in the new database. Then use an append query
to append the data you want in the new table to do the work?
 

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

Copy and Paste Between Databases 1
data entry using 2k7 not viewable in 2k7 but is viewable in 2k3 1
Copying and pasting 0
Comparing two databases? 4
Automatically insert data 1
Backup Data = Recordset Not Updatable 9
DAO vs ADO 5
Creating new Access 2007 database and importing the old data 1

Top