我写好了，才导入6万多数据（数据库里有千万级数据）执行起来特别慢，哪位大神给看下，是不是哪里有错
Insert into A1 (B1,B2)
SELECT B1,B2 FROM OpenDataSource('Microsoft.ACE.OLEDB.12.0','Data Source=
"d:\15.xls";
User ID=admin;Password=;Extended properties=Excel 8.0')...Sheet1$
where B1 not in (select B1 from A1 group by B1)
group by B1,B2
对了，导入之后还要把不重复的导出来