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