Thank you for the information. Spent some more time trying to get the "insert" query to work today and puff, got it.
private void insertTable()
{
OleDbConnection conn = GetConnection();
OleDbCommand cmd;
OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM scan", conn);
cmd = new OleDbCommand("INSERT INTO scan ([COL1], [COL2], [COL3]) " +
"VALUES (@Var1, @Var2, @Var3)", conn);
cmd.Parameters.Add("@Var1", OleDbType.VarChar).Value = "1";
cmd.Parameters.Add("@Var2", OleDbType.VarChar).Value = "2";
cmd.Parameters.Add("@Var3", OleDbType.VarChar).Value = "3";
cmd.ExecuteNonQuery();
da.InsertCommand = cmd;
conn.Close();
retrieveTables();
}
Thanks again works great!