Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.
... and I've imported namespaces to try to resolve this ...
Dim dbadp As New OleDbTableAdapter("Select * From Sheet1$", "provider=Microsoft.Jet.OLEDB.4.0;Data Source='Your Filename';Extended Properties=Excel 8.0;") Dim dTable As New DataTable dbadp.Fill(dTable) dbadp.dispose() For i As Integer = 0 To dTable.Rows.Count - 1 dbcmd.commandtext = "Update SQLTable Set OrderNo=" & dTable.Rows(i).Item("OrderNo") & " Where ItemNo=" & dTable.Rows(i).Item("ItemNo") & " AND Location='" & dTable.Rows(i).Item("Location") & "'" dbcmd.ExecuteNonQuery() Next
|display data in text field from data base for updating||6||30|
|In Excel 2007, how should I change my formula so I don't get a #VALUE error?||3||28|
|EXCEL formula help required||3||15|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
12 Experts available now in Live!