I am trying to insert about 200 rows right now in one go.
I am using a discoonected recordset and making 200 rows with addnew function and doing batchupdate at the end.The cursor i am using is adkeyset and adbatchoptimistic.

please suggest a better way out,probably using a stored proc and calling it 200 times ???

I am using the Microsoft OLEDB Provider,so if something can be done by calling some OLEDB API,,,,do suggest that....?

Thanx in advance.