Hello again.
I'm currently working on reorganizing a datatable in a fairly complex Excel application. The problem that I'm running into is this:
I have an ORDER BY clause in my SQL expression (Microsoft Query via an ODBC connection).
SELECT A, B, C, D
FROM some tables
WHERE some criteria
GROUP BY some nonsense
HAVING some more criteria
ORDER BY Region, State, Location, Submarket, Project
However, at some point in the several months this application has been in use, it has been sorted.
If I paste this into a new file, it returns the records in the correct order. However, the Excel table that we're using in the application only orders by Project. I can't get it to "refresh" and use the order by clause in the SQL query.
Any thoughts?
DWig
I'm currently working on reorganizing a datatable in a fairly complex Excel application. The problem that I'm running into is this:
I have an ORDER BY clause in my SQL expression (Microsoft Query via an ODBC connection).
SELECT A, B, C, D
FROM some tables
WHERE some criteria
GROUP BY some nonsense
HAVING some more criteria
ORDER BY Region, State, Location, Submarket, Project
However, at some point in the several months this application has been in use, it has been sorted.
If I paste this into a new file, it returns the records in the correct order. However, the Excel table that we're using in the application only orders by Project. I can't get it to "refresh" and use the order by clause in the SQL query.
Any thoughts?
DWig
