Skip to main content
Topics#IntegrationAbraham Ramirez's Question
Abraham Ramirez asked in #Integration
Apr 22, 2015, 12:39 AM

Integration Professional Salesforce with SQL or VBA Excel through ADO (ActiveX Data Objects)

Hello, This topic may be old but I'm 3 days trying to access to salesforce's database. Really I have a project to send data from Excel to Salesforce.

Does exist any driver to get integration SQL Server or Office (desirable Excel) with version Professional from Salesforces?

I'm expert in database management with ADO, I would use similar code as following:

Set con = CreateObject("adodb.connection")

Set rs = CreateObject("adodb.recordset")

con.Open "Provider=sqloledb; Data Source=SERVIDOR;Initial Catalog=DATABASE; User Id=XYZ; Password=ABC;"

rs.Open "SELECT * FROM Account", con

Range("A1").CopyFromRecordset rs

Set rs = Nothing

Set con = Nothing

After, I would use SQL Statement like INSERT and UPDATE

Why?

Excel template are used by salesmen and engineers in my company and then I have others people writing again the same information in salesforce!!!

For the moment I have found ODBC Driver but it asked request  to Salesforce: Enterprise Edition , Performance Edition, Unlimited Edition o Developer Edition.

Regards and Thanks a lot in Advance.

Abraham
2 answers
Write an answer...
0/9000