Read Huge Excel - Getting error

Hi Team,

While reading the huge size excel (more than 50 MB) getting below error:I tried excel scope and read range.

Read Range: Object reference not set to an instance of an object.

Please help.

Hi @loginerror

Please help…

@saransrs

Instead of using Read Range activities or Excel application scope,

You can use Excel as database, and execute queries
Check below post

Mark as solution if this helps you

Thanks

Hi @ksrinu070184

Hi have 7lakhs line item in my excel…

@saransrs

Excel Application scope can’t handle huge excel,

so you can use as database, check below

Thanks

Hi @ksrinu070184

I am getting below error:
Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine

Do i need to install Access Database Engine Redistributable 2016

Please confirm

Hi @saransrs

@sharathraju489 might help you in this

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

@saransrs

Try to import ‘ System.Data.OleDb ’ in your workflow.

also you need to install Access Database Engine too

Check below post

Hope this may help

Thanks

Hi @ksrinu070184

still getting the same error…

@saransrs

Install Access Database Engine

Hope this works

Thanks