External data connection to excel

BillBill 💎
edited May 12, 2020 in Questions
Thanks for the new data connections.  Since so many companies have data sitting in excel.  Has anyone created an external connection to excel? I have many excel databases that each have over 1 million records that I do not want to store in Salesforce.  I would rather have them in a free account on amazon.  Does anyone have a solution for this?

Comments

  • Rob HatchRob Hatch 💎💎💎
    edited September 1, 2016
    Sooo.  You have to get your data on a server somewhere before you can access it through the cloud.  We're never going to be able to integrate with data on your hard drive.  But once you have excel in Sharepoint, or in Excel 365 etc.  There are a number of REST APIs available for the integration.  YMMV because we can't integrate with just any data source,  but theoretically it is possible. 
  • BillBill 💎
    edited May 12, 2020
    What is YMMV?  It is in excel 365. So, how is this done?
  • edited April 11, 2017
    Bill - re YMMV: http://netforbeginners.about.com/od/xyz/f/What-Is-YMMV.htm

    I had to look it up myself. Rob is so street.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!