+ Start a Discussion

Integration with Access

Is there a way to link access tables to SalesForce and perform updates/add/deletes?


1)  Data Junction (or it's newer replacement product) can transfer information between Access and salesforce.com. (see the Data Junction discussion group).

2) You could use the API to roll your own solution.

3) The up-coming Office Toolkit (COM support) could probably, when available, be used effectively from with Access. This facility allows the sf.com API to be called from VBA and has been used to build a comparable facility within Excel.  This would not be trivial, but could be much easier than (2). See topics in the Visual Basic discussion group for what information is available on the toolkit.




You are welcome to use our tool free for a week to update salesforce.com from Access.  You can get it from www.demandtools.com.