Data source dates sheet

[koltregaskes]

I have many sources of data for our database and would like to track the dates we receive these sources.

Initially the Excel source is renamed and copied to our network via an Access VBA script, which checks for the latest source. From here, once it finds a source it runs an Excel macro which then updates a "data source" Excel sheet with the current date and time. The "data source" sheet lists all the sources I have in one column with columns for time and date (among other things) and the macro updates a specific cell before going back to Access to carry on checking and copying data sources.

I'm wondering if there is a much easier way to track the data sources dates on a Excel worksheet?

 

[mole999]

if your using sql from access maybe add a field that is appended to data as it is output with the time stamp

SELECT
field,
field,
field,
GETUTCDATE() as [timestamp]
from
DATASOURCE