VC++中用Excel实现数据库表的导入与导出

Load and store of database table through Excel in VC++

在分析了OLE技术的基础上,介绍了在VC++环境中实现Excel与SQL Server数据库数据表的双向传输的方法。同时,在Excel中指定列标题的前提下,实现了Excel中数据的有选择性读取,增加了程序的灵活性。

After analyzing the OLE technology, the load and store of database table in VC＋ ＋ environment by adding Excel header to project is introduced, and the different editions of Excel header are discussed. Meanwhile, the method of reading data in Excel dynamically after setting column header is introduced, which increases program flexibility.