Hi,
I'm exporting table from access to system and importing the table.The table is getting saved but its not readable and not getting imported also.I have follow the below code,
if (radioButton7.Checked == true)
{
da = new OleDbCommand(Delete from xxx", con);
da.ExecuteNonQuery();
foreach (DataRow dr in dt.Rows)
{
OleDbCommand da1 = new OleDbCommand("insert into xxx values("+dr[0].ToString()+",'"+dr[1].ToString()+"','"+dr[2].ToString()+"','"+dr[3].ToString()+"',"+dr[4].ToString()+","+dr[5].ToString()+",'"+dr[6].ToString()+"','"+dr[7].ToString()+"',"+dr[8].ToString()+",'"+dr[9].ToString()+"','"+dr[10].ToString()+"',"+dr[11].ToString()+",'"+dr[12].ToString()+"','"+dr[13].ToString()+"','"+dr[14].ToString()+"','"+dr[15].ToString()+"',"+dr[16].ToString()+",'"+dr[17].ToString()+"')", con);
da1.ExecuteNonQuery();
}