To copy a table to another table (access)

[mohana_61]

hey frds,
help me i don know the how to copy the content from one table to another(in access) using oledb,dataset..
for clear understanding i gve eg.,
there r 2 tables, the 1st table with the fields studentID,StudentName, Course,Year and 2nd table with the fields studentID,StudentName, Course,Year,marks,grade. here i want the studentID,StudentName, Course,Year frm 1st table to be copied to 2nd table...using oledb..
help me ...
thanks in advance

[kRod]

How about just using a query to do the work unless you want to edit the data.

INSERT INTO newTable (fieldList)
SELECT fieldlist
FROM oldTable

[mohana_61]

thanks KRod for ur reply...
can u help me by providing the full coding...