本人想通过将excel导入SQLSERVER2000服务器;但现在遇到一个问题
如果是在局域网内导入远程服务器这不行,本机没问题,请问题如何解决???以下是C#.net2005导入代码:
if (this.openFileDialog1.ShowDialog() == DialogResult.OK)
{
this.Cursor = Cursors.WaitCursor;
string strimp="exec HR_IMP '" + openFileDialog1.FileName + " '";
try
{
DB.ExecuteSQL(strimp);
MessageBox.Show("数据导入成功!");
}
catch (SqlException ae)
{
MessageBox.Show(ae.Message.ToString());
}
this.Cursor = Cursors.Default;
}
------------------------------------
存储过程如下:
create proc HR_IMP
@path varchar(500)
as
delete from tb_youxiaouser
declare @sql varchar(8000)
set @sql='insert tb_youxiaouser(WEIJIBIANMA,NASHUIRENJC,DIANHUA,YOUXIAORIQI,CHUANJIANREN)
select WEIJIBIANMA,NASHUIRENJC,DIANHUA,YOUXIAORIQI,CHUANJIANREN from openrowset(''Microsoft.Jet.OLEDB.4.0'',''EXCEL 8.0;HDR=YES;User id=admin;Password=;IMEX=1;DATABASE='\\192.168.0.201\共享文档\+@path+''', sheet1$)'
exec(@sql)
go
如果是在局域网内导入远程服务器这不行,本机没问题,请问题如何解决???以下是C#.net2005导入代码:
if (this.openFileDialog1.ShowDialog() == DialogResult.OK)
{
this.Cursor = Cursors.WaitCursor;
string strimp="exec HR_IMP '" + openFileDialog1.FileName + " '";
try
{
DB.ExecuteSQL(strimp);
MessageBox.Show("数据导入成功!");
}
catch (SqlException ae)
{
MessageBox.Show(ae.Message.ToString());
}
this.Cursor = Cursors.Default;
}
------------------------------------
存储过程如下:
create proc HR_IMP
@path varchar(500)
as
delete from tb_youxiaouser
declare @sql varchar(8000)
set @sql='insert tb_youxiaouser(WEIJIBIANMA,NASHUIRENJC,DIANHUA,YOUXIAORIQI,CHUANJIANREN)
select WEIJIBIANMA,NASHUIRENJC,DIANHUA,YOUXIAORIQI,CHUANJIANREN from openrowset(''Microsoft.Jet.OLEDB.4.0'',''EXCEL 8.0;HDR=YES;User id=admin;Password=;IMEX=1;DATABASE='\\192.168.0.201\共享文档\+@path+''', sheet1$)'
exec(@sql)
go
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货