Microsoft Excel Driver(*.xls, *.xlsx, *.xlsm,*.xlsb)

Davitor

Hi All I am useing Microsoft Excel Driver for creating a database (i.e. Excel sheet).it's working only for .xls formate.But it's not create for .xlsx formate.Code is here

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;

plz help me

David Crow

So where's the problem?

"Old age is like a bank account. You withdraw later in life what you have deposited along the way." - Unknown

"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons

Davitor

problen is .xlsx file formate not work.