What is the fastest way to writing access db. I want to write around 1 million of records. Currently I'm using 'Microsoft.Jet.OLEDB.4.0' connection, but it gets around 30 Min to complete that task. please let me know about a solution for this.
Thanks,
kasun.