如题,通过Ado连接excel,获取excel中“顾客编号”,“顾客姓名”,“销售金额”三列值,并对“销售金额”进行汇总。其中“顾客编号”列已设置为文本类型,当“顾客编号”列中出现“0”开头的值时,得到的顾客编号为空值。请问如何解决?谢谢~
con.Open "provider=Microsoft.Jet.OLEDB.4.0;data source=" & txtPath.Text & ";Extended Properties=""Excel 8.0;hdr=yes;imex=1"""
rs.Open "select 顾客编号,顾客姓名,sum(销售金额) as 公司程序报单金额 from [sheet1$] group by 顾客编号,顾客姓名 order by 顾客编号", con, 3, 3
con.Open "provider=Microsoft.Jet.OLEDB.4.0;data source=" & txtPath.Text & ";Extended Properties=""Excel 8.0;hdr=yes;imex=1"""
rs.Open "select 顾客编号,顾客姓名,sum(销售金额) as 公司程序报单金额 from [sheet1$] group by 顾客编号,顾客姓名 order by 顾客编号", con, 3, 3
顾客编号不是固定长度的,如果不对excel做改动,只改VB的代码有办法实现吗?
if Excel的顾客编号=0 then rs!顾客编号="0" 应该就可以了