function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
orikkerorikker 

Access 2007 queries to SalesForce.com

Is it possible to create queries in MS Access 2007 that will pull data from SalesForce.com??

Details would be helpful,

Thanks,

Oleg.
werewolfwerewolf
You might try this as an ODBC driver:

http://www.openaccesssoftware.com/products/openrda/salesforce_overview.asp

I can't vouch for it as I haven't tried it, but it's worth a look.
orikkerorikker

Thanks, I was hoping for something free, since we already pay maaaaad money for SalsForce and Microsoft Office anyways.

 
SnowMoreSnowMore
You can download the Office Tookit, which is free and includes everything you need to query Salesforce.com from Access.  It's not easy to find -- there are tons of postings on this discussion board asking where to find it.  It's somewhere on developer.force.com.
SnowMoreSnowMore

Here's a link to the Office Toolkit:

 
SnowMoreSnowMore
I should add that the Office Toolkit requires you to write some VBA code in Access.  You will not be creating an Access Query that directly queries the Salesforce data, but rather writing VBA code that connects to and queries Salesforce.   To have Salesforce tables appear as a tables for plain Access queries, you have to buy the ODBC drivers.