将SQL数据库中的数据读到ACCESS和EXCEL里.docVIP

// CDAccessDlg.cpp : 实现文件 #include stdafx.h #include CDAccess.h #include CDAccessDlg.h #include DbSqlite.h #include afxdb.h #include afxdao.h #include Afxdlgs.h #include afxdb.h #ifdef _DEBUG #define new DEBUG_NEW #endif //导入COM口 #import C:\Program Files\Common Files\System\ado\msadox.dll #import C:Program Files/Common Files/System/ado/msado15.dll rename(EOF, adoEOF) //生成C++类，改变EOF函数的名称 using namespace ADODB; // 用于应用程序“关于”菜单项的CAboutDlg 对话框 class CAboutDlg : public CDialog { public: CAboutDlg(); // 对话框数据 enum { IDD = IDD_ABOUTBOX }; protected: virtual void DoDataExchange(CDataExchange* pDX); // DDX/DDV 支持 // 实现 protected: DECLARE_MESSAGE_MAP() }; CAboutDlg::CAboutDlg() : CDialog(CAboutDlg::IDD) { } void CAboutDlg::DoDataExchange(CDataExchange* pDX) { CDialog::DoDataExchange(pDX); //DDX_Control(pDX, IDC_LIST1, m_listRw); } BEGIN_MESSAGE_MAP(CAboutDlg, CDialog) END_MESSAGE_MAP() // CCDAccessDlg 对话框 CCDAccessDlg::CCDAccessDlg(CWnd* pParent /*=NULL*/) : CDialog(CCDAccessDlg::IDD, pParent) { m_hIcon = AfxGetApp()-LoadIcon(IDR_MAINFRAME); m_pDBOpera = new CSqliteConn; } void CCDAccessDlg::DoDataExchange(CDataExchange* pDX) { CDialog::DoDataExchange(pDX); DDX_Control(pDX, IDC_LIST1, m_listResult); } BEGIN_MESSAGE_MAP(CCDAccessDlg, CDialog) ON_WM_SYSCOMMAND() ON_WM_PAINT() ON_WM_QUERYDRAGICON() //}}AFX_MSG_MAP ON_BN_CLICKED(IDOK, CCDAccessDlg::OnBnClickedOk) ON_BN_CLICKED(IDC_SQL, CCDAccessDlg::OnBnClickedSql) ON_BN_CLICKED(IDC_ACCESS_CREATE, CCDAccessDlg::OnBnClickedAccessCreate) ON_BN_CLICKED(IDC_COPY, CCDAccessDlg::OnBnClickedCopy) ON_CBN_SELCHANGE(IDC_COMBO_DEPT, CCDAccessDlg::OnCbnSelchangeComboDept) // ON_BN_CLICKED(IDC_BUTTON1, CCDAccessDlg::OnBnClickedButton1) ON_BN_CLICKED(IDC_COPY_EXCEL, CCDAccessDlg::OnBnClickedCopyExcel) END_MESSAGE_MAP() // CCDAccessDlg 消息处理程序 BOOL CCDAccessDlg::OnInitDialog() { CDialog::OnInitDialog(); // 将“关于...”菜单项添加到系统菜单中。 // IDM_ABOUTBOX 必须在系统命令范围内。 ASSERT((IDM_ABOUTBOX 0xFFF0) == IDM_ABOUTBOX); ASSERT(IDM