Importing? or copying data between data bases

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

Guest

I have two databases that contain names and various information. One database
is a complete list of names that I would like in the other database. Can I do
that somehow without retyping them all into the incomplete data base?
Additionally, I would like new names entered to be in both databases when
entered in either one. If someone can point me in the right direction, I
think I can take it from there.
 
By "database" I presume you mean database and not table.

Take the first database and split it into a backend and a front end. Use Get
External Data - Import and import any tables that are in the second database
that are not in the first database. Create any relationships that are
needed. Take the second database and delete all the tables. Use Get External
Data - Link and link to the backend of the first database.

Both databases share a common set of tables so any data entered by one
database is always available to the other database.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
Thanks Steve. I actually have two access databases and tables to go with
each. I am beginning to realize that is very redundant, but don't know quite
how to fix it at this point. One is a complete list of church members with
vital statistics. The other is a list of members and the work they are
interested in doing at the church. I would like to get all the members names
into the work database. I think I need to do some more learning about
relationships. I can do reports pulling from both databases, but can't do
queries.

I think this is not a good question. :0
 
Your work database ought to look something like:
TblMember
MemberID
FirstName
MI
LastName
<<Fields with vital statistics>>

TblWork
WorkID
WorkDesc

TblMemberWorkInterest
MemberWorkInterestID
MemberID
WorkID

I would like to offer to merge your two databases into one database. My fee
would be very reasonable.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
I'll be happy to send you my church membership database which does exactly
this, free of charge. Just send an email address to jvinson <at> wysard of
info <dot> com.

John W. Vinson [MVP]
 
Thank you John.

John W. Vinson said:
I'll be happy to send you my church membership database which does exactly
this, free of charge. Just send an email address to jvinson <at> wysard of
info <dot> com.

John W. Vinson [MVP]
Click to expand...
 
Still soliciting?

These newsgroups are provided by Micrososft for free peer to peer support.

John... Visio MVP
 
Still soliciting?

These newsgroups are provided by Micrososft for free peer to peer support.

John... Visio MVP
 
So where is your free peer to peer support. All you provided are two
worthless repetitive responses and not one iota of help to the OP. Of
course, it is obvious that you are not even smart enough to only respond
once.
 
You are the only one who does not understand that my free support is doing
garbage collection by handling the trash you post to the newsgroups.

These newwsgroups are for free peer to peer support and your blatant
solicitation are agaisnt the rules and spirit of these newsgroups. If you
want to provide honest help, I will not interfere, but each time you cross
the line, I will warn the unsuspecting users of your reputation. Why do you
not grow up and get a real job.

John... Visio MVP
 
You are the only one who does not understand that my free support is doing
garbage collection by handling the trash you post to the newsgroups.

These newwsgroups are for free peer to peer support and your blatant
solicitation are agaisnt the rules and spirit of these newsgroups. If you
want to provide honest help, I will not interfere, but each time you cross
the line, I will warn the unsuspecting users of your reputation. Why do you
not grow up and get a real job.

John... Visio MVP
Click to expand...

He is probably not even capable of performing the task.
 
Back
Top