VC++通过ODBC将数据导出到excel

CDatabase

A CDatabase object represents a connection to a data source, through which you can operate on the data source. A data source is a specific instance of data hosted by some database management system (DBMS). Examples include Microsoft SQL Server, Microsoft Access, Borland^® dBASE^®, and xBASE. You can have one or more CDatabase objects active at a time in your application.

Note   If you are working with the Data Access Objects (DAO) classes rather than the Open Database Connectivity (ODBC) classes, use class CDaoDatabase instead. For more information, see the articlesDatabase Topics (General) andDAO and MFC. Both articles are in Visual C++ Programmer's Guide.

To use CDatabase, construct a CDatabase object and call its OpenEx member function. This opens a connection. When you then construct CRecordset objects for operating on the connected data source, pass the recordset constructor a pointer to your CDatabase object. When you finish using the connection, call the Close member function and destroy the CDatabase object. Close closes any recordsets you have not closed previously.

For more information about CDatabase, see the articlesData Source (ODBC) andDatabase Topics (General) in Visual C++ Programmer's Guide.

#include <afxdb.h>

CDatabase Class Members

Data Members

m_hdbc

Open Database Connectivity (ODBC) connection handle to a data source. Type HDBC.

Construction