how to feed table values of MS Access database into sql2008 database table

first you need to get the data from access like

OledbConnection acon=new OledbConnection("u r connection string here");
OledbCommand acmd=new OledbCommand("Select * From Table",acon);
OledbAdapter ada=new OledbAdapter(acmd);
DataSet ads=new DataSet();
ada.Fill(ads);
foreach(DataRow dr in ads.Tables[0].Rows)
{
int _id=Convert.ToInt32(dr["Id"].ToString());
SqlConnection cn=new SqlConnection("Sql ConnectionString Here");
SqlCommand cmd=new SqlCommand(Insert Into Table(Id)Values("+_id+"))";
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}

can u give me an example pls... its new for me...

should the column fields be the same in both table or it doesnt matter ??? 


thanks for t reply....

you can try like get the values from access table and then insert into sql server table.

DataSet ds=GetFromAccess();
foreach(DataRow dr in ds.Tables[0].Rows)
{
//create variables for each column and acces values
int _id=Convert.ToInt32(dr["Id"].ToString());
//here insert into sql database
}