Macros and Im/Exporting

[CJ]

Can I use a Macro to Export some information from one DB
to the desktop of a user and then use another Macro on the
other database to Import the data from the stuff saved on
the desktop???

CJ

 

[John Nurick]

Yes, provided the other user is logged in to his computer at the time
and provided the network security settings allow you to write to his
desktop.

But if you have those permissions on his machine it would seem simpler
to export the data directly to the other database. If you don't, export
the data to an intermediate file - CSV format, perhaps - and email it to
the other user.

 

[CJ]

Permissions aren't a problem. If DB to DB is the best way
to go then how do I go about that? Which Macro would be
the better one to use?

-----Original Message-----
Yes, provided the other user is logged in to his computer at the time
and provided the network security settings allow you to write to his
desktop.

But if you have those permissions on his machine it would seem simpler
to export the data directly to the other database. If you don't, export
the data to an intermediate file - CSV format, perhaps - and email it to
the other user.

Can I use a Macro to Export some information from one DB
to the desktop of a user and then use another Macro on the
other database to Import the data from the stuff saved on
the desktop???

CJ

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.

 

[John Nurick]

Depends on exactly what's going on.

One way would be to set up linked tables in your database connected to
the actual tables in the other user's. Then use ordinary append (or
other) queries in your database to move the data.

Otherwise, the macro action for moving things between mdb files is
TransferDatabase (in VBA, DoCmd.TransferDatabase).

Permissions aren't a problem. If DB to DB is the best way
to go then how do I go about that? Which Macro would be
the better one to use?

-----Original Message-----
Yes, provided the other user is logged in to his computer at the time
and provided the network security settings allow you to write to his
desktop.

But if you have those permissions on his machine it would seem simpler
to export the data directly to the other database. If you don't, export
the data to an intermediate file - CSV format, perhaps - and email it to
the other user.

Can I use a Macro to Export some information from one DB
to the desktop of a user and then use another Macro on the
other database to Import the data from the stuff saved on
the desktop???

CJ

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.