Importing data from Excel is VERY SLOW !!!

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

I'm opening an Excel Worksheet in VB and use the cells
object to read it's cells data.

This operation is going very slow. Is there a way of
accelerating this operation (like reading larger blocks
of information instead of one cell at a time ?)

Thanks,

Daniel
 
Daniel,

Another way I've been using a lot, with very good speed
even on large spreadsheets, is to link the Excel
spreadsheet in my database and read it as a table, without
opening Excel. Even if the spreadsheet changes names and
moves around from one folder to another, it's very easy to
change the links from VB (I do it all the time).

Nikos
 
Back
Top