Sql Server数据库导入
if exists(select * from sysobjects where name='OutsideCall')
delete from OutsideCall
INSERT INTO OutsideCall(TeleNumber)
SELECT convert(varchar(20), convert(bigint,TeleNumber) ) FROM OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Excel5.0;HDR=YES;DATABASE=***.xls',[Sheet1$]) where TeleNumber not in(select TeleNumber from OutsideCall);"