在EXCEL宏的VB编辑器中:
Set Sheet = ThisWorkbook.ActiveSheet
MsgBox Sheet.Cells(7, "A")
End Sub
如何将 Sheet.Cells(7, "A") 导入 Microsoft SQL server中?
Set Sheet = ThisWorkbook.ActiveSheet
MsgBox Sheet.Cells(7, "A")
End Sub
如何将 Sheet.Cells(7, "A") 导入 Microsoft SQL server中?
strFileName = dirname & filename & ".xls"
adoConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & strFileName & ";Extended Properties='Excel 8.0;HDR=Yes'"
adoRecordset.Open "select * from [students.sheet$] ", adoConnection, adOpenKeyset, adLockOptimistic
Do While Not adoRecordset.EOF
'读数据显示,Sheet.Cells(7, "A") 实际上就是第7行中A字段的数据
loop
adoRecordset.close
adoConnection.close
或者说在vb中调用dts之类的东东?有没有代码啊?谢谢了!