Read Range from Excel help

Help Activities
, ,
1

Hello,

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.

Thanks,

Tim

2

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:

image

Does this help?

Cheers
Andrzej

3

Thanks, I think this will resolve the issue.

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