#include <odbcinst.h>
#include <afxdb.h>

class CExcel  
{
private:
	CDatabase m_database;
public:
	void Close();
	bool Write(CString param1);
	bool Open(CString filename);
	CExcel();
	virtual ~CExcel();

};

#include "Excel.h"



CExcel::CExcel()
{
}

CExcel::~CExcel()
{
}

bool CExcel::Open(CString filename)
{
	// exactly the same name as in the ODBC-Manager
	CString sDriver = "MICROSOFT EXCEL DRIVER (*.XLS)"; 
	// Filename and path for the file to be created
	CString sExcelFile = filename;                
	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( m_database.OpenEx(sSql,CDatabase::noOdbcDialog) )
		{
			
			// drop old table
			try
			{
				sSql = "DROP TABLE results";
				m_database.ExecuteSQL(sSql);
			}
			catch(CException *pEx)
			{
				pEx->Delete();
			}

			// recreate new table structure
			sSql = "CREATE TABLE results(my_values TEXT)";

			// write value
			m_database.ExecuteSQL(sSql);			
			
		}

	}
	catch(CException *pEx)
	{
		pEx->ReportError();
		pEx->Delete();

		return false;
	}
  
	return true;
}

bool CExcel::Write(CString  param1)
{
	try
	{	

		CString sSql = "INSERT INTO results(my_values) VALUES ('";
		sSql += param1;		
		sSql += "')";

		m_database.ExecuteSQL(sSql);	

	}
	catch(CException *pEx)
	{
		pEx->ReportError();
		pEx->Delete();

		return false;
	}
  
	return true;
}

void CExcel::Close()
{
	// Close database
	if(m_database.IsOpen())
		m_database.Close();

}