Dim strPath As String
Dim strSQL As String = "SELECT * FROM [Sheet1$]"
Dim strConn As String = "provider=Microsoft.Jet.OLEDB.4.0; data source=" & strPath & ";Extended Properties=Excel 8.0;"
以上是EXCEL接口,现在我要改为WPS,怎么写呀
...全文
4242打赏收藏
wps电子表格数据导入到ORACLE数据库表中接口问题
Dim strPath As String Dim strSQL As String = "SELECT * FROM [Sheet1$]" Dim strConn As String = "provider=Microsoft.Jet.OLEDB.4.0; data source=" & strPath & ";Extended Properties=Excel 8.0;" 以上是EXCEL接口,现在我要改为WPS,怎么写呀