I'm working on a project that imports an Excel file into a database. It's 99% done, and now I have run into a problem. This is a bit long, but I could use some help.

I have a class in the project which represents column info:

public class ExcelExportColumnInfo
{
    private ColumnType _Type;
    private string _DBColumnName = "";
    private string _ExcelColumnName = "";

    public enum ColumnType
    {
        String,
        Int32
    }

    public ColumnType Type
    {
        get { return _Type; }
        set { _Type = value; }
    }

    public string ExcelColumnName
    {
        get { return _ExcelColumnName; }
        set { _ExcelColumnName = value; }
    }

    public string DBColumnName
    {
        get { return _DBColumnName; }
        set { _DBColumnName = value; }
    }
}

I then create instances of the column info class for each column in the Excel file that is to be imported into the database:

// Collection to hold the column information
ArrayList Columns = new ArrayList();

// One object for each column
ExcelExportColumnInfo Col1 = new ExcelExportColumnInfo();
Col1.DBColumnName = "Customer";
Col1.ExcelColumnName = "Conctrac # -- Customer";
Col1.Type = ExcelExportColumnInfo.ColumnType.String;
Columns.Add(Col1);

ExcelExportColumnInfo Col2 = new ExcelExportColumnInfo();
Col2.DBColumnName = "Quantity";
Col2.ExcelColumnName = "Quantity";
Col1.Type = ExcelExportColumnInfo.ColumnType.Int32;
Columns.Add(Col2);

ExcelExportColumnInfo Col3 = new ExcelExportColumnInfo();
Col3.DBColumnName = "PartNumber";
Col3.ExcelColumnName = "Part Number";
Col1.Type = ExcelExportColumnInfo.ColumnType.String;
Columns.Add(Col3);

ExcelExportColumnInfo Col4 = new ExcelExportColumnInfo();
Col4.DBColumnName = "Location";
Col4.ExcelColumnName = "Ship To";
Col1.Type = ExcelExportColumnInfo.ColumnType.String;
Columns.Add(Col4);

// Call the method to export the sheet to the database
Excel.ExportSheetToDB(ExpInfo, Columns);

The second column's Type property should be ExcelExportColumnInfo.ColumnType.Int32.

Please see the following pic: http://marois.freewebspace.com/pic1.JPG. Notice that somehow it is being stored in the property as a string.

Anyone know what's wrong here?

Thanks.