1、查询Access中数据的方法:
select * from OpenRowSet('microsoft.jet.oledb.4.0',';database=c:/db2.mdb','select * from serv_user')
或select * from OpenDataSource('Microsoft.Jet.OLEDB.4.0'
SQL Server和Access数据读写
最新推荐文章于 2022-07-18 15:30:38 发布
1、查询Access中数据的方法:
select * from OpenRowSet('microsoft.jet.oledb.4.0',';database=c:/db2.mdb','select * from serv_user')
或select * from OpenDataSource('Microsoft.Jet.OLEDB.4.0'