Copying table data to different database

[m450n86]

Hi All,

I need some help on copying one table from a database to another database at a different location (not a linked table).

All of our data entry users have access to two drives:
G drive and O drive

The G drive holds the data entry and management database called "RequestDatabase" in which the data is written to a table called 'Master'
The O drive will hold the master table data for management to run reports and should have a portable copy of the 'Master' table and not linked to it called "ReportDatabase".

Management have access to the O drive only.

How do I have our data entry database execute a command to copy over the Master table from the RequestDatabase over to the ReportDatabase.

Before anyone suggests a linked table, this won't work as management don't have access to the drive the requestdatabase is stored for security reasons.

Help Help Help is much appreciated :-)

[CJ_London]

use the transferdatabase method to copy the table - https://msdn.microsoft.com/en-us/lib.../ff196455.aspx