Graphics

 View Only

  • 1.  SQL Query for sorting Excel data

    Posted 04-20-2016 23:08
    I was watching the XPression Datalinq 104 tutorial on using an SQL query to sort data. I successfully set up the Excel link, and can see the table date, but as soon as I type the SQL query, the table data disappears. Any ideas?


  • 2.  RE: SQL Query for sorting Excel data

    Posted 04-21-2016 12:37
    You're probably typing an invalid query.. If you post a screenshot we might be able to spot the issue.
    #XPression


  • 3.  RE: SQL Query for sorting Excel data

    Posted 04-21-2016 17:03
    Thanks. Our engineers are just reinstalling some cabling, so I will do that as soon as possible.
    #XPression


  • 4.  RE: SQL Query for sorting Excel data

    Posted 04-25-2016 16:37
    I had another look on Friday and was able to get the SQL query to work. Not sure what I was doing wrong the first attempt.
    #XPression