Exporting data between different mdb files?

[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

 

[Peter Doering]

Gary,

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)

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

 

[gm]

Gary,





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

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.

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