Forum Discussion
HimChanVit Cho
Jan 23, 2018Copper Contributor
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 ChoCopper Contributor
current cunnection -> connection property modifiy -> definition -> order type : SQL, and ORDER TEXT = SQL text
- JKPieterseSilver ContributorUse Microsoft Query.