CString GetExcelDriver()
{
wchar_t szBuf[2001];
wchar_t excl[] = L"Excel";
WORD cbBufMax = 2000;
WORD cbBufOut;
wchar_t *pszBuf = szBuf;
CString sDriver;
// 获取已安装驱动的名称(函数在odbcinst.h里)
if (!SQLGetInstalledDrivers(szBuf, cbBufMax, &cbBufOut))
return L"";
// 检索已安装的驱动是否有Excel...
// AfxMessageBox(CString(pszBuf));
do
{
if(wcsstr(pszBuf, excl) != 0)
{
//发现 !
sDriver = CString(pszBuf);
break;
}
wchar_t ze = {'\0'};
pszBuf = wcschr(pszBuf, ze) + 1;
}
while (pszBuf[1] != '\0');
return sDriver;
}
{
wchar_t szBuf[2001];
wchar_t excl[] = L"Excel";
WORD cbBufMax = 2000;
WORD cbBufOut;
wchar_t *pszBuf = szBuf;
CString sDriver;
// 获取已安装驱动的名称(函数在odbcinst.h里)
if (!SQLGetInstalledDrivers(szBuf, cbBufMax, &cbBufOut))
return L"";
// 检索已安装的驱动是否有Excel...
// AfxMessageBox(CString(pszBuf));
do
{
if(wcsstr(pszBuf, excl) != 0)
{
//发现 !
sDriver = CString(pszBuf);
break;
}
wchar_t ze = {'\0'};
pszBuf = wcschr(pszBuf, ze) + 1;
}
while (pszBuf[1] != '\0');
return sDriver;
}