1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
| CString m_str_path;
CString m_str_file;
CDatabase database;
CString sSql;
CString sItem1, sItem2;
CString sDriver;
CString sDsn;
CString sFile = "ReadExcel.xls";
CString m_sExcelDriver = "toto";
CString m_sFile = "C:\\Classeur1.xls";
sDsn.Format("DSN=MS Access Database;DBQ=C:\db1.mdb;DefaultDir=C:;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;");
sDsn.Format(_T("DRIVER={%s};DSN='';FIRSTROWHASNAMES=1;READONLY=FAL SE;DRIVERID=790;DBQ=%s"), m_sExcelDriver, m_sFile);
database.Open(NULL, false, false, sDsn);
CRecordset recset(&database);
sSql = "SELECT * FROM employe;";
recset.Open(CRecordset::forwardOnly,sSql,CRecordset::readOnly);
while (!recset.IsEOF())
{
// Read the result line
recset.GetFieldValue("nom", sItem1);
recset.GetFieldValue("prenon", sItem2);
m_list.AddString(sItem1);
m_list.AddString(sItem2);
//
CLASSEDIT rs(&database);
rs.Open( CRecordset::snapshot,
_T( "select * from employe" ));
rs.AddNew();
rs.m_nom= "club";
rs.m_prenon= "africain";
rs.Update();
rs.Close(); |
Partager