Home Forums SQL Server 2008 T-SQL (SS2K8) import data from excel only from specific cells RE: import data from excel only from specific cells
Yev-704641
SSC Enthusiast
Points: 127
More actions
February 19, 2013 at 3:34 pm
#1589394
WHen adding Excel Source and under "Show Advanced Editor" and in Component Properties you could specify your own OpenRowset like Sheet1$A3:H3 where A3 is first column and H3 is last column to read data from.