With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
... 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
|Multi-user Excel not reflecting who actually has the file opened||10||30|
|Unable to save view in SSMS||21||53|
|Interview questions for support of a legacy ASP.NET site||4||37|
|Excel copy picture into Outlook email||7||41|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
10 Experts available now in Live!