Access导入sql 2005

EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'Ad Hoc Distributed Queries', 1
GO
RECONFIGURE
GO

INSERT INTO IPToCity(IP_Start,IP_End,IP_Province,IP_City)

SELECT IP_Start,IP_End,IP_Province,IP_City

FROM opendatasource('Microsoft.Jet.OLEDB.4.0',
'Data Source="d:\DataBase.mdb";User ID=;Password=')...IPToCity

posted @ 2010-03-19 10:00  小さいです哥  阅读(203)  评论(0)    收藏  举报