Specified Cast Invalid on MS Access database!

[one320b]

I've read through numerous postings by other users here but was not able to find the solution to my issue. It's probably a simple one, but it's racking me at this point.

I have two databases in MS Access with a table "Affiliatio n". Both contain four columns/fields. I am writing an application to pull some data from Table1's affiliation table and inserting it into Table2's affiliation table. The datatypes are all the same for all four fields in both tables, but for some reason I get an error "specified cast is invalid" on my final field. Here is the code I'm using:

 while(CMDReader.Read())
    {    
SQL_Command2 = "INSERT INTO tblAffiliation(AffiliationID, [Short], [Long], Affiliation) VALUES(" + CMDReader.GetInt32(0) + ",'" + CMDReader.GetString(1) +"', '" + CMDReader.GetString(2) + "', " + CMDReader.GetInt32(3) + ")";
 
OleDbCommand InsertCMD = new OleDbCommand(SQL_Command2, FAC_Data);
 
InsertCMD.ExecuteNonQuery();
 
    }

on the "CMDReader.GetI nt32(3)" is where the casting error occurs. It's datatype is an Integer in the MS Access table. The first "CMDReader.GetI nt32(0)" works fine, so I don't understand why this one doesn't. The only difference is that the "0" is a long integer datatype in the table and the "3" is simply an integer.

Any thoughts?

[one320b]

Actually - nevermind, I just switched it and didn't do any conversions, etc.

I just switch the method from GetInt32(3) which wasn't working to simply GetValue(3) and all is fine now. It may not be the best method - but this application is not exactly labor or memory intensive so no big deal.