Viewing 3 posts - 1 through 3 (of 3 total)
see attachment
November 21, 2012 at 1:59 am
#1561132
you can add expression of excelversionnumber, if xlsx set the value to 4 if xls set to 3
November 21, 2012 at 1:32 am
#1561118
you can use sqlcmd in execl source,
press buildquery,add table, then add top 100.that you can got it.
SELECT TOP 5 [2012-11-16], F2, F3, F4, F5, F6, F7, F8
FROM ...
November 20, 2012 at 11:33 pm
#1561098