. . . string lcStr1; string lcStr2; string lcStr3; double lnAmt; OleDbConnection concxn = new OleDbConnection(strConn); concxn.Open(); OleDbCommand cmd = new OleDbCommand(strQuery, concxn); OleDbCommand cmdInsert = new OleDbCommand("insert into MyTarget (cust_id, Company, country, orderamt) values ( ?,?,?,? )", concxn); cmdInsert.Parameters.Add("customer_id", OleDbType.Integer,0); cmdInsert.Parameters.Add("company", OleDbType.VarChar,30); cmdInsert.Parameters.Add("country", OleDbType.VarChar,30); cmdInsert.Parameters.Add("orderamt", OleDbType.Numeric,0); cmdInsert.Prepare(); OleDbDataReader readr = cmd.ExecuteReader(); while (readr.Read()) { cmdInsert.Parameters[0].Value = readr[0]; cmdInsert.Parameters[1].Value = readr[1]; cmdInsert.Parameters[2].Value = readr[2]; cmdInsert.Parameters[3].Value = readr[3]; cmdInsert.ExecuteNonQuery(); } . . .HTH.