ADO导出EXCEL数据的时候,由于有多国语言,转换过程中总是出现乱码,怎么解决?
火鸟33 2007-10-30 05:56:06 pStream.CreateInstance("ADODB.Stream");
_variant_t varOptional(DISP_E_PARAMNOTFOUND,VT_ERROR);
pStream->raw_Open(varOptional,adModeUnknown,adOpenStreamUnspecified,NULL,NULL);
pStream->Type = adTypeText;
pStream->Charset = _T("ISO-8859-2");
pStream->WriteText((_bstr_t)pRst->GetFields()->GetItem((_variant_t)arrStrColName[i].GetBuffer(1))->GetValue(),adWriteChar);
pStream->Position = 0;
pStream->Charset = _T("ISO-8859-2");
arrStrContent[lRecordNum][i] = (wchar_t*)(_bstr_t)pStream->ReadText(adReadAll);
pStream->Close();