Search results

  1. C

    Put dates into Oracle table from MS Access

    Now() Now is an Access function that Oracle doesn't understand. In the INSERT statement the now is part of the statement and Oracle doesn't know how to interpret it. In the second example using a recordset, the value of now is written to the access recordset. If you want to use the INSERT try...
  2. C

    SQL syntax in VBA for an Append To query

    Select...into Try SELECT...INTO...
Back
Top Bottom