怎么把本地EXCEL里的数据导入到远程服务器的SQL里
我做的能导入到本地SQL里,远程的出错误
string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source =" + @FileSource + ";Extended Properties=Excel 8.0";
myConn = new OleDbConnection(strCon); myConn.Open(); //打开数据链接,得到一个数据集
DataSet myDataSet = new DataSet(); //得到自己的DataSet对象
string StyleSheet = "Sheet1";
string StrSql = "select * from [" + StyleSheet + "$]"; OleDbDataAdapter myCommand = new OleDbDataAdapter(StrSql, myConn);
myCommand.Fill(myDataSet, "[" + StyleSheet + "$]");
myCommand.Dispose();
DataTable DT = myDataSet.Tables["[" + StyleSheet + "$]"];
myConn.Close();
............
我做的能导入到本地SQL里,远程的出错误
string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source =" + @FileSource + ";Extended Properties=Excel 8.0";
myConn = new OleDbConnection(strCon); myConn.Open(); //打开数据链接,得到一个数据集
DataSet myDataSet = new DataSet(); //得到自己的DataSet对象
string StyleSheet = "Sheet1";
string StrSql = "select * from [" + StyleSheet + "$]"; OleDbDataAdapter myCommand = new OleDbDataAdapter(StrSql, myConn);
myCommand.Fill(myDataSet, "[" + StyleSheet + "$]");
myCommand.Dispose();
DataTable DT = myDataSet.Tables["[" + StyleSheet + "$]"];
myConn.Close();
............
string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source =" + @FileSource + ";Extended Properties=Excel 8.0";
// strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +@"Data Source= ……文件地址" + ";" +"Extended Properties=Excel 8.0;";
myConn = new OleDbConnection(strCon); myConn.Open(); //打开数据链接,得到一个数据集
一般来说,只要有权限,连接字符串正确,没有被防火墙喀嚓,
那写入本地和写入远程没区别再多说一句,有权限的话不需要写程序,直接用sql2k的dts