Import the Revenue File

1. Create a new tab titled: “RawData”.

2. In the “Data” tab copy from A5:I##.

3. In the Raw Data tab paste these Values Only beginning at A1.

4. Do a Control-Shift-End and make sure there are no extra or empty rows or columns.

5. Modify the Revenue Excel file with the following columns and import into a work table in MySQL: FiscalYear, ISDCode, ISDName, DistrictCode, DistrictName, SfdFundCode, SfdFunctionCode, SfddObjectCode, SfdAmount.

6. Import Excel file “RawData” tab into the MySQL temp table: “aa_mi_se_fid_rev”.

7. Run the MuSQL scripts in: “SE MI Import FID Utilities”.