• Sean Kelly
  • NEWBIE
  • 0 Points
  • Member since 2004

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies

I have a general question on what people use to fix or clean records that when ACCOUNT, FIRST_NAME, LAST_NAME are dirty. I cannot use the website's import tool to update records since there were several dirty imports undertaken without a test plan.

I have a lead source that is keyed on custom fields (staffid for CONTACT, bigdough_instid for ACCOUNT) and want to be able to periodically update records based on those keys through the use of SQL.

Is there a way to manipulate my company's salesforce.com data using something akin to SQLPlus or TOAD without writing an application?