Exporting data between different mdb files?

  • Thread starter Thread starter gm
  • Start date Start date
G

gm

I have set iup a student information database called SCHOOL.

On of my colleagues uses a mdb called RECORDS and another uses an mdb
called VISITS.

I want to collect data (records) from each of the other two and
incorporate them into SCHOOL.

Any ideas as to how I should be approaching this?
(Reference to an example would be helpful)

Thanks

Gary
 
Gary,
I have set iup a student information database called SCHOOL.
Click to expand...
On of my colleagues uses a mdb called RECORDS and another uses an mdb
called VISITS.
Click to expand...
I want to collect data (records) from each of the other two and
incorporate them into SCHOOL.
Click to expand...
Any ideas as to how I should be approaching this?
(Reference to an example would be helpful)
Click to expand...

The online help should have examples. Search for Import, Link and, if you
want to automate the process, TransferDatabase.

To do it manually from the DB-window: menu File - Get external data -
Import, rest should be obvious.

HTH - Peter
 
Gary,





The online help should have examples. Search for Import, Link and, if you
want to automate the process, TransferDatabase.
Click to expand...

I tried that before asking here - couldn't spot what I wanted.
To do it manually from the DB-window: menu File - Get external data -
Import, rest should be obvious.
Click to expand...

I don't have permanent access to their files. I'd like to be able to
(once a week) get a file off them containing either all, or the
recently updated records in their database table.

Gary
 
Back
Top