Hi,
I am trying to write some code that will allow me to perform checks on a file containing linked data (queries). My objective is to copy across the data source from 1 file over to a cell in the main file for verification.
The linked data is output from SQL in a CSV format but the filename needs to be verified on a monthly basis to ensure that the source hasn't changed.
Is there an easy way of doing this?
Thanks
I am trying to write some code that will allow me to perform checks on a file containing linked data (queries). My objective is to copy across the data source from 1 file over to a cell in the main file for verification.
The linked data is output from SQL in a CSV format but the filename needs to be verified on a monthly basis to ensure that the source hasn't changed.
Is there an easy way of doing this?
Thanks