Database

CDatabase database;
CString sDriver = "MICROSOFT EXCEL DRIVER (*.XLS)";  // exactly the same name as in the ODBC-Manager

CString sExcelFile =_T("C:\\Users\\Admin\\Desktop\\1.xls");// Filename and path for the file to be created

CString Query_Str="";

TRY  
{ 

	Query_Str.Format(_T("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(Query_Str,CDatabase::noOdbcDialog) )
	{
		// Create table structure
		Query_Str = "CREATE TABLE demo (Name TEXT)";
		database.ExecuteSQL(Query_Str);

		// Insert data
		Query_Str = "INSERT INTO demo (Name) VALUES ('Albert')";
		database.ExecuteSQL(Query_Str); 

		//add column
		Query_Str = "ALTER TABLE demo ADD Col2 TEXT";
		database.ExecuteSQL(Query_Str);
	}
	// Close database
	database.Close();

}  
CATCH_ALL(e)
{    
	AfxMessageBox(e->ReportError());
}
END_CATCH_ALL;

can u please help me to ALTER TABLE with DEFAULT

Eddy Vluggen wrote:

First add all the columns and do the insert when all columns are present, or
make sure that the column you're going to add accepts null-values.

Le@rner wrote:

get all column name list of current database.

Did you mean get all column name list of current table.

Blue_Boy wrote:

Did you mean get all column name list of current table.