如果能有例程就好了，多谢大家帮忙，^_^！

給一個使用 ADO 的例子吧.:


#include <iostream>

// 導入 ado 庫
#import "C:\\Program Files\\Common Files\\system\\ado\\msado15.dll" no_namespace \
rename("EOF", "EndOfRecordset")

using namespace std;

int main()
{
CoInitialize(NULL);
long i;

_ConnectionPtr hConn("ADODB.Connection");
_CommandPtr hCmd("ADODB.Command");
_RecordsetPtr hRds("ADODB.Recordset");

// 打開 Excel 數據庫
hConn->Open("Driver={Microsoft Excel Driver (*.xls)};DBQ=C:\\Book1.xls", "", "", 0);
hCmd->ActiveConnection = hConn;

// 準備讀取表 Sheet1
hCmd->CommandText = "SELECT * FROM [Sheet1$]";
hRds = hCmd->Execute(NULL, NULL, 0);

// 列出 ColumnHeaders, 這裏與其他的數據庫不同, 它的 ColumnHeader 實際就是第一行數據
for(i=0; i<hRds->Fields->Count; i++)
cout << (char*)((_bstr_t)hRds->Fields->Item[i]->Name) << '\t'; //
cout << endl;

// 列舉數據
while(! hRds->EndOfRecordset)
{
for(i= 0; i<hRds->Fields->Count; i++)
cout << (char*)((_bstr_t)hRds->Fields->Item[i]->Value) << '\t';
cout << endl;
hRds->MoveNext();
}

hConn->Close();
CoUninitialize();
system("pause");
return 0;
}