V4
2014 FLPA Script when all history years exist (2013, 2012, 2011, 2010, 2009
2014 FLPA Script when history years (2013, 2012, 2011, 2010) exist
2014 FLPA Script when history years (2013, 2012, 2011) exist
2014 FLPA Script when history years (2013, 2012) exist
2014 FLPA Script when history years (2013) exist
Script is intended to run from AY2014 in SSMS or SQLMaster. Running query will create two record sets. The first record set is to be saved as a CSV named FLPAAUDIT_DATA.CSV and record set 2 should be named FLPABREACH_DATA.CSV
Create a folder on C drive named FLPAAUDIT2014
Save the first record set as C:\FLPAAUDIT2014\FLPAAUDIT_DATA.CSV (FLPAAUDIT_DATA)
Save the second record set as C:\FLPAAUDIT2014\FLPABREACH_DATA.CSV (FLPABREACH_DATA)
Both CSV files should be saved into C:\FLPAAUDIT2014\ along side of the FLPAAUDIT.XLSX spreadsheet.
Open the C:\FLPAAUDIT2014\ folder where you've saved the CSV and XLSX files
OPEN both CSV files (does not matter which one you open first)
After opening the CSV files, OPEN the FLPAAUDIT.XLSX file to open and update the links. Your spreadsheet should update to show the current data within the csv files