Home Forums SQL Server 2012 SQL Server 2012 - T-SQL SSIS Import from Excel RE: SSIS Import from Excel
tindog
SSCarpal Tunnel
Points: 4892
More actions
October 8, 2015 at 4:41 am
#1832246
I don't have the means to test at the moment - perhaps this would work?
SELECT *
FROM [Sheet1$B2:Q2]
UNION
FROM [Sheet1$B9:Q]