终于搞定ACCESS批量插入SQL 2005

Express不提供批量导入，只能用代码了，下面是代码，搞了半个小时搞定：



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

INSERT INTO [PKData].[dbo].[game_info]( [game_rootid], [game_name_c], [game_descri_c], [game_size], [game_hits], [game_server], [game_path] )

SELECT [game_rootid], [game_name_c], [game_descri_c], [game_size], [game_hits], [game_server], [game_path]
FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source=F:\site\pkdoor\App_Data\flash.mdb')...game_info