[p]在做項(xiàng)目時(shí)，經(jīng)常遇到要將excel中的大量數(shù)據(jù)導(dǎo)入到access數(shù)據(jù)庫(kù)中，原來(lái)的做法是讀一條寫(xiě)一條，若導(dǎo)入上萬(wàn)條的數(shù)據(jù)需要幾分仲時(shí)間，速度很慢。有沒(méi)有最快的方法呢？經(jīng)本人研究、反復(fù)的實(shí)驗(yàn)，終于寫(xiě)出了最快速的批量導(dǎo)入大批量數(shù)據(jù)的方法，上萬(wàn)條數(shù)據(jù)只需幾秒鐘就可全部導(dǎo)入，夠快了吧。代碼公布出來(lái)與大家分享。[br]set conn = server.createobject("adodb.connection") [br]connstr = "provider=microsoft.jet.oledb.4.0; data source=" & server.mappath("test.mdb") [br]conn.open connstr [br]sql = "insert into userinfo select username,useraccount,userstatus from [userinfo$] in '" & server.mappath("hbwluserinfo.xls") [br] & "' 'excel 8.0;' where useraccount is not null" [br]conn.execute (sql)[/p]