C / C++ / MFC

<br />
	  CDaoDatabase database;<br />
	  CDaoRecordset recordset(&database);<br />
	  CString lpszFile = "c:\\Database.mdb";<br />
	  database.Create(lpszFile);<br />
	  database.Open(lpszFile);<br />
	  CString SqlCmd = "CREATE TABLE MYTable.mdb (MarketNo VARCHAR(2),MarketName VARCHAR(8),Bid VARCHAR(10),Ask VARCHAR(10),MarketState VARCHAR(2))";<br />
      database.Execute(SqlCmd);<br />
      recordset.Open(AFX_DAO_USE_DEFAULT_TYPE,"SELECT * FROM MyTable",0);<br />
	  database.Execute("INSERT INTO MyTable(MarketNo)");<br />
      database.Execute("INSERT INTO MyTable(MarketName)");<br />
	  database.Execute("INSERT INTO MyTable(Bid)");<br />
	  database.Execute("INSERT INTO MyTable(Ask)");<br />
	  database.Execute("INSERT INTO MyTable(MarketState)");<br />
	  recordset.AddNew();<br />
	  recordset.SetFieldValue("MarketNo","a");<br />
      recordset.SetFieldValue("MarketName",Market);<br />
      recordset.SetFieldValue("Bid","b");<br />
	  recordset.SetFieldValue("Ask","c");<br />
	  recordset.SetFieldValue("MarketState","d");<br />
      recordset.Update();<br />
      recordset.MoveNext();<br />
      recordset.AddNew();<br />