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 0 Newbie Poster
jsj1411 0 Newbie Poster
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 239 Master Poster
Have a look at this article: http://www.daniweb.com/software-development/vbnet/threads/423833/datatable-to-access-database-table
Reverend Jim 4,968 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster
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.