
If the spreadsheet was in a share accessible to the computer running SQL server, then you could have a data check run from a scheduled report. The data check could run an SQL script to import the Excel file into a temporary table, before using that temporary table to perform the update on affected assets.
Did you get this to work? I'd be interested to know more about the lockers..
1 comment