關于excel,access裡的内容導到sqlserver資料庫的問題?

用sql語句直接導入比較友善，快捷

1.查詢excel

select *

from opendatasource( 'microsoft.jet.oledb.4.0',

  'data source="c:/finance/account.xls";user id=admin;password=;extended properties=excel 5.0')...xactions

2.導入

insert into table1(field1, field2, field3, field4, field5)

select a1, a2, a3, a4, a5

insert  into  b表  selet  *  from  openrowset('microsoft.jet.oledb.4.0',   

     'x:/a.mdb';'admin';'',a表)

select * into aaa from opendatasource('microsoft.jet.oledb.4.0',

 'data source="e:/ccc.mdb")...table