ADO访问中文表名的时候出错(ACCESS数据库),帮忙啊!!!!
Dim rsRZ As New ADODB.Recordset
cnString = "driver={microsoft access driver (*.mdb)};dbq=" _
& FileName & ";uid=sa;pwd="
sqlString = "select * from " & "企业信息"
rsRZ.CursorType = adOpenKeyset
rsRZ.LockType = adLockOptimistic
rsRZ.Open sqlString, cnString, , , adCmdTable
错误提示如下:
实时错误 [microsoft][ODBC mICORSOFT ACCESS 驱动程序] From 子句语法错误
但是在ACCESS中执行没有问题。而且表的名称不能修改。如何访问中文名称表名用ADO。只要正确一定加分,急急急急急急!!!!!