呵呵,看看merge的说明:
http://www.foxtable.com/help/topics/0685.htm
默认是access格式,如果是其他格式,你得明确指定格式才行,例如示例八:
Dim mg As New Mergermg.SourcePath = "c:\data\销售管理.xls"mg.Format = "excel" '指定格式mg.SourceTableName = "订单" '指定要合并的表mg.DataTableName = "订单" '指定接收数据的表mg.Merge() '开始合并