C / C++ / MFC

GetDlgItemText(IDC_EDIT1,m_getfilename);
	CDatabase database;
 //getfilename(get filepath and name run time)
 CString sDriver="Microsoft Excel Driver(*.xls, *.xlsx, *.xlsm,*.xlsb)"; //DRIVER=
  CString sExcelFile = m_getfilename;                // Filename and path for the file to be created

  CString sSql;
    
  TRY
  {
    // Build the creation string for access without DSN
       
    sSql.Format("DRIVER={%s};DSN='';FIRSTROWHASNAMES=1;READONLY=FALSE;CREATE_DB=\"%s\";DBQ=%s",
                sDriver, sExcelFile, sExcelFile);


	 

	
    // Create the database (i.e. Excel sheet)
    if( database.OpenEx(sSql,CDatabase::noOdbcDialog) )
    {
      // Create table structure
		
      sSql = "CREATE TABLE demo (Name TEXT,Age NUMBER)";
      database.ExecuteSQL(sSql);

      // Insert data
      sSql = "INSERT INTO demo (Name,Age) VALUES ('Bruno Brutalinsky',45)";
      database.ExecuteSQL(sSql);

      sSql = "INSERT INTO demo (Name,Age) VALUES ('Fritz Pappenheimer',30)";
      database.ExecuteSQL(sSql);

      sSql = "INSERT INTO demo (Name,Age) VALUES ('Hella Wahnsinn',28)";
      database.ExecuteSQL(sSql);
	  sSql = "INSERT INTO demo (Name,Age) VALUES ('Bruno Brutalinsky',45)";
      database.ExecuteSQL(sSql);

      sSql = "INSERT INTO demo (Name,Age) VALUES ('Fritz Pappenheimer',30)";
      database.ExecuteSQL(sSql);

      sSql = "INSERT INTO demo (Name,Age) VALUES ('Hella Wahnsinn',28)";
      database.ExecuteSQL(sSql);

	  sSql = "INSERT INTO demo (Name,Age) VALUES ('Bruno Brutalinsky',45)";
      database.ExecuteSQL(sSql);

      sSql = "INSERT INTO demo (Name,Age) VALUES ('Fritz Pappenheimer',30)";
      database.ExecuteSQL(sSql);



    }      

    // Close database
    database.Close();

  }
  CATCH_ALL(e)
  {
    TRACE1("Driver not installed: %s",sDriver);
  }
  END_CATCH_ALL;

strurl = "http://www.lowcostholidays.com/webservices/search.asmx"
        
             xmlHttp.Open "POST", strurl, False
             xmlHttp.setRequestHeader("Accept", "*/*")
           xmlHttp.setRequestHeader"Referer", "http://www.lowcostholidays.com")                   xmlHttp.setRequestHeader("Content-Type", "text/xml")
             xmlHttp.setRequestHeader("User-Agent", "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 1.1.4322; .NET CLR 3.0.04506.648; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)")
             xmlHttp.setRequestHeader("Host", "www.lowcostholidays.com")
             xmlHttp.setRequestHeader("Connection", "Keep-Alive")
             xmlHttp.setRequestHeader("Cache-Control", "no-cache")

             xmlHttp.setRequestHeader("Cookie", strCookie(it))
             xmlHttp.send (strpostdata)