function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
drober01drober01 

Integration with Access

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

Drober,

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.

Scot

GlennWGlennW

Drober;

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.

GlennW