jsabo
08-21-2013, 03:17 PM
Hello,
I am trying to get my VBA script to upload a date in a certain active cell (M1 for instance) to an Oracle database. NOTE: The date format i am going for is "DD/MM/YYYY"
Here is the SQL script in VBA that i currently have:
SQL_String = " UPDATE activities " & _
"SET ALOG_ACTUAL_DATE = " & _
ActiveSheet.Range("M" & i) & " WHERE " & _
"PO_SEQNO = " & ActiveSheet.Range("G" & i)
As is, i dont think it will wind up in SQL in "DD/MM/YYYY" format. Can anyone help to edit the above to fix that?
Thanks!
I am trying to get my VBA script to upload a date in a certain active cell (M1 for instance) to an Oracle database. NOTE: The date format i am going for is "DD/MM/YYYY"
Here is the SQL script in VBA that i currently have:
SQL_String = " UPDATE activities " & _
"SET ALOG_ACTUAL_DATE = " & _
ActiveSheet.Range("M" & i) & " WHERE " & _
"PO_SEQNO = " & ActiveSheet.Range("G" & i)
As is, i dont think it will wind up in SQL in "DD/MM/YYYY" format. Can anyone help to edit the above to fix that?
Thanks!