Updating Assignment Level Data From SQL With VBA RRS feed

  • Question

  • Microsoft Project 2010 (SP1)

    What is the magic syntax to update assignment level data ([Work]) in VBA from a prepopulated SQL database?  Assume I am using the Assignment UID as the Primary Key.

    I can get the field to update when I set the value manually within VBA, but I just need help figuring out how to get the SQL query to work from within VBA.

    Thanks in advance.

    Andrew Lavinsky [MVP] Blog: Twitter: @alavinsky
    Saturday, October 8, 2011 10:25 PM


  • Never mind.  Got it figured out.  Instead of looking for a recordset, I should have been using a GetString command with the SQL query.  Thanks.

    Andrew Lavinsky [MVP] Blog: Twitter: @alavinsky
    Sunday, October 9, 2011 2:49 PM