We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
... 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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|VBA kill active workbook in before close event with condition||3||35|
|ASP.NET VB code for check and insert in a table||4||38|
|Migrate SQL 2005 DB to SQL 2016||4||18|
|Permutacion of 2 numbers COUNT||8||19|
Join the community of 500,000 technology professionals and ask your questions.