Importing data from Excel is VERY SLOW !!!

[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

 

[Douglas J. Steele]

Have you tried TransferSpreadsheet?

 

[Daniel]

Yes,
I thought of this also, and now I tried it - Works great.

Thank you !

Daniel

 

[Nikos Yannacopoulos]

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