Transferring records between database

[ibbledibble]

Hi

We have the same database set up in three different offices - it is not shared. I want to run a macro to export and email individual records from a database in one office, and import them from the email to the database in another office. Is this possible without exporting and emailing the whole dataset?

Thanks!

 

[datAdrenaline]

It is my opinion that an option to consider would be to export to a CSV from the "Source" database, then import those CSV's into the "Destination" database.

Another option is to programmatically create an Access mdb file with an accommodating table structure, then send that single MDB. Then at the destination, you can run a routine that imports (appends) the records to the destination.
...

Also, do any of the offices share any network resources ... ie: is there a file server that can be seen by all offices?

 

[ibbledibble]

Hi

The offices do not share file servers but the databases are identical. I don't know which is the easier one to program (I don't know any VB), but it has to be one record at a time - it's basically a referral process that has already had some work carried out on the record.