导入DBF库数据需要在服务器端安装DBF库的驱动程序。
private void InsertMemberInfo()
{
CMS.BLL.MemberManage mm = new CMS.BLL.MemberManage();
string sql =" insert into CMS_MemberT from OPENROWSET('MSDASQL','Driver={Microsoft Visual FoxPro Driver}; SourceDB=d://website//XZSEC//admin//memberDBF;SourceType=dbf','select * from member.dbf') ";
mm.GetExeCmdResult(sql);
mm.Dispose();
}