Getting error while reading 5 lacs records from excel

[hzaman (Hasan)]

While reading 5 lacs records getting error “Online excel error something”
But while reading 3 lacs records , its working fine.

RAM available 4GB
Kindly help me , for that any specific infra is required to done this activity.

[Manjuts90]

@hzaman how u reading from excel?

[hzaman (Hasan)]

Using Read Range Object and addressing “A1:P500000”

[anujmca31 (Anuj Choudhary)]

Can you please post your error screen-shot?

[Manjuts90]

@hzaman u can try by connecting excel as database and get the data, i think it might work

[hzaman (Hasan)]

Is there option available in community version. I am unable to find option to connection build in UI path.

[Manjuts90]

@hzaman use connect database activity

[loginerror (Maciej Kuźmicz)]

@hzaman See this topic for reference:

Connection string for excel

Hi Can any one help me connection strings for excel. what needs to be provided in the connection string for excel. I have scenario where i need to query the excel. I had huge data with multiple columns, i need to use filters for multiple columns and base on each filter i need to set a value for the filtered results. Thanks for the help in advance.