数据库写入问题


我在VC中向ACCESS数据库写数据,写20000条记录要3分钟,这个正常吗,是不是我的程序有问题呀,我没有每次都打开记录集吧?应如何更改速度才快呀?
void CQueryRecordDlg::OnButton4() 
{
// TODO: Add your control notification handler code here
CString sql_;
_bstr_t sql;
_RecordsetPtr pRecordset; m_RecordDBCnt.CreateInstance(__uuidof(Connection)); 
sql="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=record.mdb;Mode=ReadWrite;Persist Security Info=False;Jet OLEDB:Database Password=1qaz2wsx3edc";
m_RecordDBCnt->ConnectionString =sql; 
m_RecordDBCnt->Open("","","",NULL);  sql_.Format("INSERT INTO EntryExitFile(HolderNo,HolderName,CTRno,CTRdoorNo,Location,EntryExit,CardNo,Re,SDFlag) VALUES('%s','%s','%s','%d','%s','%s','%s','%s','%s')","","jj","",5,"ss","","777777","","");
sql=sql_; try
{
for(int i=0;i<20000;i++)
{
m_RecordDBCnt->Execute(sql,NULL,adCmdText);
}
AfxMessageBox("1234");
} catch(_com_error e)///捕捉异常
{
AfxMessageBox(e.Description());///显示错误信息
}
}