把Access里的表数据全部映射到SS2005中对应的表中

/*利用下列语句可以直接把Access里的表数据全部映射到SS2005中对应的表中
*/
exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure
Go
delete from Table_Access_To_Sql_Test
Go 
set IDENTITY_INSERT Table_Access_To_Sql_Test ON
Go
insert   into Table_Access_To_Sql_Test(seqno,Product_Num,Product_Name,Qty)
 select  seqno,Product_Num,Product_Name,Qty from   openrowset('Microsoft.Jet.OLEDB.4.0',    
        'D:/db1.mdb';'Admin';'',Table_Access_To_Sql_Test)
-- where SeqNo<> (select max(seqno) from openrowset('Microsoft.Jet.OLEDB.4.0',    
--        'D:/db1.mdb';'Admin';'',Table_Access_To_Sql_Test) )

Go
exec sp_configure 'Ad Hoc Distributed Queries',0
reconfigure
exec sp_configure 'show advanced options',0
reconfigure
Go 
set IDENTITY_INSERT Table_Access_To_Sql_Test OFF
Go
select * from Table_Access_To_Sql_Test
--