1 2 3 4 5 6 7 8 9 10 11
| Sub test()With CreateObject("Adodb.connection")
.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & ActiveWorkbook.Path & "\TEST_Rating.accdb;"
.Execute "INSERT INTO [Kunden] ([requester],[Kuerzel_360T],[KundenID],[Alpha_CODE_FX_PRO],[RatingID])" _
& " VALUES (" & RetourneDbValue(f1, True) & "," & RetourneDbValue(f2, True) & "," & RetourneDbValue(f3, False) & "," & RetourneDbValue(f4, True) & "," & RetourneDbValue(f5, True) & ");"
.Close
End With
Function RetourneDbValue(V, IsTxt As Boolean)
If Trim("" & V) = "" Then RetourneDbValue = "Null": Exit Function
If IsTxt Then RetourneDbValue = "'" & Replace(V, "'", "''") & "'": Exit Function
If Val(Replace(V, ",", ".")) <> 0 Then RetourneDbValue = Replace(V, ",", ".") Else RetourneDbValue = 0
End Function |
Partager