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
aea@purcellas.comaea@purcellas.com 

excel database issues

i have third party excel spreadsheets that i would like to extract data for reports.  can salesforce interface with excel spreadsheets to generate such reports.  Primarily for fee billing and commissions payable on fees.

 

shillyershillyer

Have you tried using the Excel Connector?

 

Hope that helps,

Sati
aea@purcellas.comaea@purcellas.com

as i understand excel connector, it would intigrate excel data into salesforce for insertion into database fields.  I am merely looking for a tool to manipulate excel data WITHOUT uploading into salesforce fields.

 
sfuser206sfuser206

Not exactly sure what you're looking for, but have you looked into Connect for Office?  You can import reports into Excel and then manipulate it from there.  There's a built in function to refresh the imported reports as well.  Unlike Excel Connector, there's no feedback into Salesforce.
RichAintRichRichAintRich

There's a couple of solutions in the AppExchange. Try SuperCell from 2FootPutt. Request the Plus version (works with Excel). Each SF org is entitled to one free license of the Plus version. Website link: http://www.2footputt.com

 

Use the following link for SuperCell with Excel (Plus version):
 
http://www.plug-and-chug.com/2footputt/SuperCell/Plus/SuperCellPlus.zip
 
The Plus version can be evaluated on a trial basis for 15 days with no obligation or you may apply for a free license.