Hi Folks
Iam trying to insert values into my access table using c# and iam at my wits end
My Access table has the following fields
Country State Curr VAT and Exchange
I have made them all as text for ease of use in the access database

this is my attached code, can you let me know where iam wrong as i get this weird error
Ole db error Datatype mismatch configaration

//Source Code 
private void CountrySaveButton_Click(object sender, EventArgs e)
            int t = 0;
            String Country = "";
            String State = "";
            String currency = "";
            string exchange = "";
            string VAT = "";
            string conString =
               + @"data source=E:\SorenProject\MedicalDataBase.mdb";
            OleDbConnection conn = new OleDbConnection(conString);
            int flag = 0;
            // create an open the connection          

            catch (Exception eqw)


 String myAddQuery = "INSERT INTO Country ([Country], [State], [Curr], [VAT], [Exchange]) VALUES('{0}', '{1}', '{2}', '{3}','{4}')";
               myAddQuery = string.Format(myAddQuery, Country, State, currency, VAT, exchange);


                    OleDbCommand myCommand = new OleDbCommand(myAddQuery, conn);

                   // conn.Open();

                    t = myCommand.ExecuteNonQuery();


                catch (OleDbException ex)

                    MessageBox.Show("OleDB Error: " + ex.Message);



You're inserting all values as strings.. are they all strings?