First create dsn for database.
#include "afxdb.h"
CDatabase m_database;
CRecordset m_recordset;
bool p=m_database.Open(_T(DSN name),0,0,_T("ODBC;"),1);
m_recordset.m_pDatabase = &m_database; m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,_T("select * from Table1"),CRecordset::appendOnly);
long reCount=m_recordset.GetRecordCount();