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
JimmyMacJimmyMac 

SOQL against Excel data possible?

Is there a way for me to run a SOQL query against an excel spreadsheet?

 

I need to write an inport/update process of my Salesforce objects, with the source data contained in Excel. Can I write SOQL against the Excel file, or do I need to export the Excel data into a Staging Object first and then run the SOQL against the Staging table?

 

Thanks to all in advance.

-Jim

Avidev9Avidev9
Well you cannot do SOQL inside a file.
You have to insert the data into a Staging object to run the SOQL
Venkat PolisettiVenkat Polisetti
JimmyMac wrote:

Is there a way for me to run a SOQL query against an excel spreadsheet?

 

I need to write an inport/update process of my Salesforce objects, with the source data contained in Excel. Can I write SOQL against the Excel file, or do I need to export the Excel data into a Staging Object first and then run the SOQL against the Staging table?

 

Thanks to all in advance.

-Jim

Looks like you have your data in an excel file. Did you try Salesforce.com Excel Connector?

 

See the link below and see if that helps you. You can do Query, Insert, Update and deletes from the Excel file itself using the plug-in.

 

https://code.google.com/p/excel-connector/

 

Thanks,