我想用sql语句建立一个查询，通过改变datatimepicker的值，显示查询结果在table控件中，以下代码报错“The Microsoft Jet database engine cannot find the input table or query '~TMPCLP客户'. Make sure it exists and that its name is spelled correctly.” 是什么问题呢？
Dim cmd As new sqlcommand
Dim dt As DataTable
cmd.commandtext="Sel ect 简称,联系人,{客户设备}.客户ID,合同号,设备号,{客户设备}.SIM卡号,计费日期,终止日期,终止原因,计费状态,账单月份,费用总计,一级账目名称,一级账目金额,二级账目金额 From (({客户} Left JOIN {联系人} ON {联系人}.[客户ID] = {客户}.[客户ID]) Left JOIN {客户设备} ON {客户设备}.[客户ID] = {联系人}.[联系人ID]) Left JOIN (Select * fr om {移动账单} where [账单月份]='" & e.Form.Controls("DateTimePicker1").VALUE & "') As a ON a.[SIM卡号] = {客户设备}.[SIM卡号] Order By {客户设备}.[客户ID],[计费日期],[终止日期]"
dt=cmd.executereader(True)
加好友 
发短信
Post By：2017/8/16 11:42:00 [只看该作者]
