Read Range from Excel help


I’m using Excel Application Scope and Read Range activities to load excel files into a SQL database.

I’m getting errors loading into the SQL database because of extra columns and rows in the Read Range variable. For some reason its adding blank columns and rows.

I set the range to “A:K” to fix the column issue but now I’m getting extra NULL rows. The row length needs to be dynamic.

Any help resolving the issue would be greatly appreciated.



Hi Tim,

If I understand correctly, you want to remove empty rows before putting them into a database?
If so, you could use a “Filter Data Table” activity like this:


Does this help?


Thanks, I think this will resolve the issue.

I’m not sure why the range is being set with extra rows though.