Copy data from Recordset to DataTable in .Net

You can copy data from Recordset to DataTable by using the following code..

ADODB.Connection oConn = new ADODB.Connection();

oConn.Open("Connection String", "", "", 0);

string strQuery = "SELECT * FROM [" + System.IO.Path.GetFileName(strFileName) + "]";

ADODB.Recordset rs = new ADODB.Recordset();

System.Data.OleDb.OleDbDataAdapter adapter = new System.Data.OleDb.OleDbDataAdapter();

DataTable dt = new DataTable();

rs.Open(strQuery, " Connection String, ADODB.CursorTypeEnum.adOpenForwardOnly, ADODB.LockTypeEnum.adLockReadOnly, 1);

adapter.Fill(dt, rs);

return dt;