exporting datagridview into ms access

[jsj1411]

i have a datagridview in my vb.net form displaying data from ms access file A , table A , is it possible for me to export the data in the data gridview to ms access file A table B?? i'm not using sql.

[jsj1411]

can you please let tell me the steps to get it done ? i'm a newbie and this is my college project i have to get it done.

[adam_k]

Have a look at this article: http://www.daniweb.com/software-development/vbnet/threads/423833/datatable-to-access-database-table

[Reverend Jim]

You don't need to do an export from the datagridview. You can do the insert directly by a query similar to the following;

insert into tableb (fieldname1,fieldname2)
    select fld1,fld2 from tablea

If you need to restrict the records from tablea then add appropriate where clauses. In your case, just use the same select clause you used to populate the datagridview.