Question import data from datagrid view to ms access database table

[sai87]

hi all,
i am new to vb.net programming i have data in datagrid view which i have extracted from ms excel now i want to import data from datagrid view to an ms access database i,e new or pre-defined access table.
please try to help me any resources or any ideas reg how to do it.

 

[jmcilhinney]

All you need is two OleDbCommands (one for Excel and one for Access), two OleDbDataAdapters (one with a SelectCommand and one with an InsertCommand) and a single DataTable. You use the first adapter to Fill the table and the second one to Update it. The only thing special you need to do is set AcceptChangesDuringFill to False on the first adapter.