Import the Balance Sheet File

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

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

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 Balance Sheet Excel file with the following columns and import into a work table in MySQL: FiscalYear, ISDCode, ISDName, DistrictCode, DistrictName, SfdFundCode, SfdFunctionCode, SfdAmount.

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

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