Forum Discussion

HimChanVit Cho's avatar
HimChanVit Cho
Copper Contributor
Jan 23, 2018
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 below state result.

 

===

SELECT a.[ROUTING_MT_CODE],a.ROUTING_DT_CODE
      ,b.SHIP_NAME   ,a.[SHIP_CODE], a.[PRODUCT_CODE] 
  FROM [SPC_OR].[dbo].[DETAIL_ROUTING] as a, [SPC_OR].[dbo].[SHIP] as b
  where a.SHIP_CODE = b.SHIP_CODE
  and a.UPDT_USER_ID='IDIDIDID' and day(a.UPDT_DT) = 23

===

 

How Can I use sql statement in excel?

  • current cunnection -> connection property modifiy -> definition -> order type : SQL, and ORDER TEXT = SQL text

  • HimChanVit Cho's avatar
    HimChanVit Cho
    Copper Contributor

    current cunnection -> connection property modifiy -> definition -> order type : SQL, and ORDER TEXT = SQL text

Resources