Forum Discussion
Solved
Get data with sql from SQL Server
I'm using excel 2010.
I want to get data from SQL Server, not just table, by sql.
excel already support this function, but it just copy a single table.
But I need to connect ...
current cunnection -> connection property modifiy -> definition -> order type : SQL, and ORDER TEXT = SQL text
Use Microsoft Query.