SQL语句如下:
string sql = @"delete vip1 insert into vip1 ( service_id,name,visit_dt,content,note,gift,if_satifac,"+
"vest_mange,recall_add,recall_typ,visitor,call_type,service_ti) "+
"select service_id,name,visit_dt,content,note,gift,if_satifac,vest_mange,recall_add,recall_typ,visitor,"+
"call_type,service_ti FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0',"+
"'Data Source="+this.filepath+"; User ID=Admin;Password=;Extended properties=Excel 8.0')...["+this.filename+"$]";