| 解决方案： |
USE ufdata_999_2001
SELECT top 1 'ACCESS'as 数据库, [cSysID], [cID], [cName], [cCaption], [cType], [cValue], [cDefault], [bVisible], [bEnable]
FROM
OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'c:tempfq.mdb';'admin';'', accinformation)
union all
SELECT top 1 'SQLOLEDB',a.[cSysID], [cID], [cName], [cCaption], [cType], [cValue], [cDefault], [bVisible], [bEnable]
FROM OPENROWSET('SQLOLEDB','(local)';'sa';'',
'select * from ufdata_999_2001..accinformation') AS a
union all
SELECT top 1 'MSSQL',[cSysID], [cID], [cName], [cCaption], [cType], [cValue], [cDefault], [bVisible], [bEnable]
from accinformation |