本人想通过将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