We help IT Professionals succeed at work.

Application crash - VB & Excel

srihv
srihv asked
on
Hi,

I am using VB to read the excel file which has got some 40000 rows. Once it finishes reading all those rows applicaiton hangs(not responding) message will come.

Please let me know how to over come this situation. And how to optimize the performace of reading excel rows, since it is taking lot of time to read 40000 rows.

Versions:
VB - 6.0
Excel - Office -97.

Thanks in advance.
Sri
Comment
Watch Question

Éric MoreauSenior .Net Consultant
CERTIFIED EXPERT
Top Expert 2016

Commented:
Show the code. There is nothing that make Excel crash after reading data!
Commented:
Are you using OLE to access the data?
If so use the ADO or DAO to access, it is alot quicker,
if you want some code, just post again


Jetforce
Richie_SimonettiIT Operations
CERTIFIED EXPERT

Commented:
Maybe, not enought memory. As guys posted previously, show how do yo do it.

Commented:
also helpful if you show/repeat ALL or error message(s)!

Explore More ContentExplore courses, solutions, and other research materials related to this topic.