Чтение таблицы из БД с помощью ADO

    HRESULT hr;
    CoInitialize(NULL);
    ADODB::_ConnectionPtr connection;
    hr = connection.CreateInstance(__uuidof(ADODB::Connection));
    ADODB::_RecordsetPtr recordset;
    hr = recordset.CreateInstance(__uuidof(ADODB::Recordset));
    if(!SUCCEEDED(hr))
        return 1;
    _bstr_t bsConnString (L"Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=C:\\Таблицы.mdb");
    _bstr_t bsUserID(L"");
    _bstr_t bsUserPwd(L"");
    connection->Open(bsConnString, bsUserID, bsUserPwd, ADODB::adConnectUnspecified);
    _bstr_t bsCommand(L"select * from ");
    bsCommand += name;
    recordset->Open(bsCommand,connection.GetInterfacePtr(),ADODB::adOpenForwardOnly, ADODB::adLockReadOnly,ADODB::adCmdText);
 
    while (!recordset->adoEOF)
    {
 
//тут должно быть чтение таблицы
 
        recordset->MoveNext();
    }
    recordset->Close();
    connection->Close();

while (!recordset->adoEOF)
    {
    FieldsPtr flds = NULL;
    recordset->get_Fields(&flds);
    int c = flds->Count;
    FieldPtr fld = NULL;
    VARIANT in;
    in.vt = VT_I4;
    in.intVal = 0; // порядковый номер поля
    flds->get_Item(in, &fld);
    VARIANT cntVar;
    fld->get_Value(&cntVar);
    recordset->MoveNext();
}

include "stdafx.h" 
#include "conio.h" 
#include "windows.h" 
#include "process.h" 
#include "stdlib.h" 
#include "string.h" 
#import "c:\program files\common files\system\ado\Msado20.tlb" \
rename ("EOF", "adoEOF")

#import "C:\Program Files\Common Files\System\ado\msado15.dll"  rename("EOF", "EndOfFile")
#import "C:\Program Files\Common Files\System\ole db\Oledb32.dll"
 
using namespace ADODB;