EXEC sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
EXEC sp_configure 'Ad Hoc Distributed Queries', 1;
GO
RECONFIGURE;
GO
Insert into sql表名(addtime,title,title_color,author,source,detail,readcount,poster,imageurl)
SELECT news_date,news_title,news_color,news_author,news_ahome,news_content,news_count,tjuser,images
FROM opendatasource('Microsoft.Jet.OLEDB.4.0','Data Source="d:\1.mdb"')...access表名
GO
RECONFIGURE;
GO
EXEC sp_configure 'Ad Hoc Distributed Queries', 1;
GO
RECONFIGURE;
GO
Insert into sql表名(addtime,title,title_color,author,source,detail,readcount,poster,imageurl)
SELECT news_date,news_title,news_color,news_author,news_ahome,news_content,news_count,tjuser,images
FROM opendatasource('Microsoft.Jet.OLEDB.4.0','Data Source="d:\1.mdb"')...access表名