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

Question

Hi friends...

   I have 2 Tables one is sql 2008 (Table_1)and one is in MS access (Table_2) .. From Table_2 [ which is in MS access has certain values ]

i have to feed those values into my Table_1[ which is in sql2008 database]... how ???

Can anyone help me please....its urgent ....

   Thank u so much for spending your valuable time ....

Krishna Garad · Answer

should be column name and datatype be same or datatype must be same atleast

Krishna Garad · Answer

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 Tableacon); 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(); }

sathish kumar · Answer

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

sathish kumar · Answer

should the column fields be the same in both table or it doesnt matter ??? thanks for t reply....

Krishna Garad · Answer

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 }