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.

Recommended Answers

All 3 Replies

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.

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.