Private Sub Command1_Click()
Data1.RecordSource = " Select 姓名 From TelTable$"
Data1.Refresh
End Sub
显示excel工作表TelTable$的"姓名"字段,结果是:数据库引擎找不到 " Select 姓名 From TelTable$"
哪位大师帮改一下!
Data1.RecordSource = " Select 姓名 From TelTable$"
Data1.Refresh
End Sub
显示excel工作表TelTable$的"姓名"字段,结果是:数据库引擎找不到 " Select 姓名 From TelTable$"
哪位大师帮改一下!
Data1.RecordSource = "Select [姓名] From [TelTable]"另外,你用的什么数据库,ODBC数据源建立了么?
Data1.Connect = "Excel 8.0"
Data1.DefaultType = 2
Data1.DatabaseName = "H:\练习\基本情况表.xls"
Data1.RecordSource = "TelTable$"
End Sub
VB codeData1.RecordSource = "Select [姓名] From [TelTable]"也不行