opendatasource打开Access数据库

开启

EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'Ad Hoc Distributed Queries', 1
GO
RECONFIGURE
GO
 
 
select * into newtable from opendatasource('Microsoft.Jet.OLEDB.4.0',
'Data Source=d:\oblog4.mdb;jet oledb:database password=123456')...[oblog_user]

posted @ 2010-12-06 10:03  s80895304  阅读(272)  评论(0)  编辑  收藏  举报