none
How to output to a text file using the Genfare Interactive SQL utility

    Question

  • How can I output data to an excel file using the Genfare Interactive SQL utility.  I would like to use the File>Save Data option, but do not know the syntax.

    Thanks

    Monday, July 01, 2013 12:13 PM

Answers

All replies

  • You are posting to the tsql forum, but your question is specific to some tool that I've never heard of.  You should post your question to a forum that is more suited to your tool - perhaps Genfare has a support forum.
    Monday, July 01, 2013 12:45 PM
  • Sorry, I asked the wrong question.

    Is there an 'SQL Statement' that would output the select query above to a text or excel file?

    Thanks.

    Monday, July 01, 2013 3:00 PM
  • You haven't given us a select statement?

    I'm assuming by "genfare interactive sql utility", you mean Genfare as in the company that handles fares for a number of transit companies across the US. If this is the case, you're more than likely using bespoke software made for the purpose of their systems and will need to advise somebody within the company to solve the problem.

    Thanks.

    Monday, July 01, 2013 3:13 PM
  • Check the below,

    Query to output to excel

    Query output into excel


    Best Luck, Shenoy

    Monday, July 01, 2013 5:07 PM