请问如何将数据库导出到Excel?
我用MFC ODBC连接数据库,我想将Access导出到Excel,
请问怎么做?
请详细告知,非常感谢!
问题点数:100、回复次数:3Top
1 楼wuxuan(真心英雄)回复于 2002-08-03 18:17:51 得分 0
gzTop
2 楼masterz(www.fruitfruit.com)回复于 2002-08-04 10:04:57 得分 100
DSNless ODBC connection string for Excel
oConn.Open "Driver={Microsoft Excel Driver (*.xls)};" & _
"DriverId=790;" & _
"Dbq=c:\somepath\mySpreadsheet.xls;" & _
"DefaultDir=c:\somepath"
Top
3 楼masterz(www.fruitfruit.com)回复于 2002-08-04 10:06:29 得分 0
HOWTO: Automate Excel Using MFC and Worksheet Functions
http://support.microsoft.com/support/kb/articles/q178/7/81.aspTop




