如何判断excel表是否已经存在?
CDatabase database;
CString sDriver = "MICROSOFT EXCEL DRIVER (*.XLS)";
CString sSql;
sSql.Format("DRIVER={%s};DSN='';FIRSTROWHASNAMES=0;READONLY=FALSE;CREATE_DB=\"%s\";DBQ=%s",sDriver, sExcelFile, sExcelFile);
if( database.OpenEx(sSql,CDatabase::noOdbcDialog) )
sSql.Format(_T("IF EXISTS() DROP TABLE %s,strExeclSheetName);//判断表是否存在怎么写?
database.ExecuteSQL(sSql);