Advertisement
| 10.02.2008 at 10:39AM PDT, ID: 23782484 |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: 73: 74: 75: 76: 77: 78: |
Sub UpDate_SQL_Server_DB2()
'Variables for the connection and recordset
Dim cnt As ADODB.Connection
Dim rst As ADODB.Recordset
'Variables for Excel
Dim wbBook As Workbook
Dim wsSheet As Worksheet
Dim rnData As Range
Dim vaExport As Variant
Dim i As Long
On Error GoTo Errorhandler
'Force a calculation of the values in E2:E65536, which updates the pace date to = today
Worksheets("SendPastData").Range("E2:E65536").Calculate
Set wbBook = ThisWorkbook
Set wsSheet = wbBook.Worksheets(1)
With wsSheet
'Populate the variant array with values from the range.
Set rnData = .Range("A2:E" & .Range("E65536").End(xlUp).Row)
vaExport = rnData.Value
End With
'Instantiate the ADO-objects
Set cnt = New ADODB.Connection
Set rst = New ADODB.Recordset
'Open the connection.
cnt.Open stCon
'Open the recordset.
'The first parameter refer to the target table's name in the DB.
rst.Open "tblTranData", cnt, 1, 3, adCmdTableDirect
'Iterate through the variant array, check if the 1st dimension's value
'(i e values from the A-column are valid and if yes then export 9 fields
'with data.
For i = 1 To UBound(vaExport)
If IsDate(vaExport(i, 1)) Then
With rst
.AddNew
.Fields("dtDate") = vaExport(i, 1)
.Fields("txtRateCode") = vaExport(i, 2)
.Fields("smlRooms") = vaExport(i, 3)
.Fields("intRevenue") = vaExport(i, 4)
.Fields("dtPaceDate") = vaExport(i, 5)
.Update
End With
End If
Next i
'Close recordset and connection.
rst.Close
cnt.Close
'Release objects from memory.
Set rst = Nothing
Set cnt = Nothing
End Sub
Errorhandler:
MsgBox Err.Description
On Error Resume Next
'Closing the recordset and connection.
rst.Close
cnt.Close
'Releasing objects from memory.
Set rst = Nothing
Set cnt = Nothing
End Sub
|
Advertisement