+ Start a Discussion

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,


You might try this as an ODBC driver:


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

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


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.

Here's a link to the Office Toolkit:


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.