Have two databases open at one time?

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

Guest

I want to have two databases open at the same time. How can I do this?

Someone created a contact database and listed contacts within it. I didn't
like the database, so I created my own. Now I want to copy and paste the
contact data (names, addresses) from the first database into my new database.
How can I do this so that I don't have to re-type the data someone already
typed in the first database?
 
I want to have two databases open at the same time. How can I do this?

Someone created a contact database and listed contacts within it. I didn't
like the database, so I created my own. Now I want to copy and paste the
contact data (names, addresses) from the first database into my new database.
How can I do this so that I don't have to re-type the data someone already
typed in the first database?
Click to expand...

It's not necessary to have both open.

Just import the tables.
Open your new database only.
Click File + Get External data + Import.
Navigate to the database. Select the table(s).
Click on Options and choose Definition and Data.
Also import the Relationships if necessary.
Click OK and the tables will be added to your new database.
 
You must log in or register to reply here.

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

Help With MS Access 4
How do I invoice a cost to a custom built MS Access Accounting Database? 0
Excel Excel - Two Database Formula extraction? 3
Access newbie needs a mentor 10
Two users in the same database at the same time 11
auto update query help 1
Duplicate Access 2007 Databases 1
Having trouble getting my current Outlook Contacts 7

Back
Top