[2.0] Datatable to MS Access

[shakti5385]

Hi all
I have datatable and MS Access table, both have same database schema.
But please tell me that without using loop can I save entire datatable to MS Access table.
Is that best way of programming?
Thanks

[jmcilhinney]

Create an OleDbDataAdapter with an appropriate InsertCommand and call its Update method, passing the DataTable as a parameter. Saving bulk data to Access is always done that way. Whether or not the data came form that database in the first place is irrelevant.

[shakti5385]

Is that best way of programming?

[mendhak]

Using MS Access?

Use what works for you. Try this out and if it works for you, good. You needn't reinvent the wheel.

[shakti5385]

Create an OleDbDataAdapter with an appropriate InsertCommand and call its Update method, passing the DataTable as a parameter. Saving bulk data to Access is always done that way. Whether or not the data came form that database in the first place is irrelevant.

Hi JMC can you describe some code