Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Insert Accounts into salesforce using DBAmp

How can i insert accounts in to salesforce from SQL using DBAmp. I have my data backup in sql under database. How can i create new table with all columns from the existing table where Field( text__c= ABC).
Note-I have almost 500 columns under account.

-- Generate empty load table for Account
Select * as Error
into Account_Load2
from SALESFORCE_PARTIAL...Account
where Text__c='ABC'

-- Push in row to insert
insert Account_Load2 (*)

-- Push to salesforce
exec sf_bulkops 'Insert','SALESFORCE_PARTIAL','Account_Load2'
1 person has
this question
+1
Reply