天天看点

使用C#把Excel格式文件的数据导入到sqlserver中

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+"$]";