Dim strSQL As String
Dim cn As New Connectioncn.Open "Provider=Microsoft.Jet.OLEDB.4.0; data souce=d:\vbphone\book1.xls;Extended Properties=Excel 10.0"
strSQL = "INSERT INTO Tphone1 SELECT * FROM [Sheet1$]"
cn.Execute strSQL, , adExecuteNoRecords有以上一代码,是想把EXCEL中的一个SHEET1数据导入到SQL中的TPHONE1中,win XP+VB6+VBSP6+远程SQL2000,执行时总是报ISAM的错!我已装过了MDAC 2.6和2.7还是不行?!!
或者那位有更好的办法来解决从EXCEL中导入SQL中已有的表中。谢谢!
Dim cn As New Connectioncn.Open "Provider=Microsoft.Jet.OLEDB.4.0; data souce=d:\vbphone\book1.xls;Extended Properties=Excel 10.0"
strSQL = "INSERT INTO Tphone1 SELECT * FROM [Sheet1$]"
cn.Execute strSQL, , adExecuteNoRecords有以上一代码,是想把EXCEL中的一个SHEET1数据导入到SQL中的TPHONE1中,win XP+VB6+VBSP6+远程SQL2000,执行时总是报ISAM的错!我已装过了MDAC 2.6和2.7还是不行?!!
或者那位有更好的办法来解决从EXCEL中导入SQL中已有的表中。谢谢!
//这个声明是dim cn as new adodb.connection
"INSERT INTO Tphone1 SELECT * FROM [Sheet1$]IN ""d:\vbphone\book1.xls"" ""EXCEL 5.0;"""