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
JustinRoffMarshJustinRoffMarsh 

How do I export a multi-tabular query?

I am currently using the OpenAccess ODBC driver in conjunction with an Access to generate a muli-tabular query (joining five tables) from a client's SF database.
 
The problem is that it takes hours (and sometimes times out).
 
I'm guessing that, if the query can run server-side, meaning that only the results need to be returned, this will solve the problem.
 
My question is, can (or should) this can be done with Apex?
 
I'm not a developer, but I've posted a job on the job board.  If I'm barking up the wrong tree, I'd appreciate very much if someone could point me in the right direction.
 
Thanks in advance.
 
Justin