#include "afxdb.h"
#include "odbcinst.h"

    CDatabase database;
  CString sDriver = "MICROSOFT EXCEL DRIVER (*.XLS)"; // Excel????
  CString sExcelFile,sPath; 
  CString sSql;
  
  //?????????,??sPath?
  GetModuleFileName(NULL,sPath.GetBufferSetLength (MAX_PATH+1),MAX_PATH);
  sPath.ReleaseBuffer ();
  int nPos;

  nPos=sPath.ReverseFind('\\');
  sPath=sPath.Left (nPos);
  nPos=sPath.ReverseFind('\\');
  sPath=sPath.Left (nPos);
  nPos=sPath.ReverseFind('\\');
  sPath=sPath.Left (nPos);
  
  sExcelFile = sPath + "\\????.xls";    // ????Excel??

  CATTry
  {
    // ??????????
    sSql.Format(_T("DRIVER={%s};DSN='';FIRSTROWHASNAMES=1;READONLY=FALSE;CREATE_DB=\"%s\";DBQ=%s"),sDriver, sExcelFile, sExcelFile);
    
    // ????? (?Excel????)
    if( database.OpenEx(sSql,CDatabase::noOdbcDialog) )
    {
      // ?????(?????)
      sSql = "CREATE TABLE Exceldemo (Name TEXT,Age NUMBER)";
      database.ExecuteSQL(sSql);
      
      // ????
      sSql = "INSERT INTO Exceldemo (Name,Age) VALUES ('???',26)";
      database.ExecuteSQL(sSql);
      
      sSql = "INSERT INTO Exceldemo (Name,Age) VALUES ('???',22)";
      database.ExecuteSQL(sSql);
      
      sSql = "INSERT INTO Exceldemo (Name,Age) VALUES ('??',27)";
      database.ExecuteSQL(sSql);
    }   
    
    // ?????
    database.Close();  
  }