excel文件怎样用代码实现远程导入sql2000数据库中~~

Question

dts 或者自己写代码啊。其实，vb就可以做到。

Answer 1

读取客户端的东东，那是不可能的，所以你必须有2步要做：
1、首先把excel上传的服务器，代码很多，你google一下，我就不贴了
2、然后通过ole读取excel，写入到sql server中，google一下也很多的。   

Answer 2

EXCEL导到远程SQLinsert OPENDATASOURCE(
         'SQLOLEDB',
         'Data Source=远程ip;User ID=sa;Password=密码'
         ).库名.dbo.表名 (列名1,列名2)
SELECT 列名1,列名2
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
  'Data Source="c:\test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions

Answer 3

谢谢上面的 的确可以在SQL2000查询分析器里面运行
可是我想通过在web form点击按纽来实现~~~
程序老是出错~~
private void Button1_Click(object sender, System.EventArgs e)
{
string s="insert OPENDATASOURCE('SQLOLEDB', 'Data Source=LSX;User ID=sa;Password=123456lsx').Economy.dbo.Book 
(BookID,BookName,BookAuthor,BookPublish,BookPrice,BookKind,BookStatus,BookInTime)
SELECT BookID,BookName,BookAuthor,BookPublish,BookPrice,BookKind,BookStatus,BookInTime
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0','Data Source=filename;User ID=Admin;Password=;Extended properties=Excel 5.0')...Sheet1$";


SqlConnection con=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["DNS"]);
SqlCommand cmd=new SqlCommand(s,con);
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection .Close();
}

Answer 4

谢谢上面的 的确可以在SQL2000查询分析器里面运行
可是我想通过在web form点击按纽来实现~~~
程序老是出错~~
private void Button1_Click(object sender, System.EventArgs e)
{
string s="insert OPENDATASOURCE('SQLOLEDB', 'Data Source=LSX;User ID=sa;Password=123456lsx').Economy.dbo.Book 
(BookID,BookName,BookAuthor,BookPublish,BookPrice,BookKind,BookStatus,BookInTime)
SELECT BookID,BookName,BookAuthor,BookPublish,BookPrice,BookKind,BookStatus,BookInTime
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0','Data Source=filename;User ID=Admin;Password=;Extended properties=Excel 5.0')...Sheet1$";


SqlConnection con=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["DNS"]);
SqlCommand cmd=new SqlCommand(s,con);
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection .Close();
}