Excel VBO - Copy specific column into collection

[Anonymous]

Hello, I'm trying to get a specific column from an excel file into a collection. Is there an easy way to do this? Currently I'm: 1. Getting an entire worksheet into a collection 2. Using a calculator to get values from that column into a new collection 3. Looping until the rows have completed This takes a long time for 20k plus rows. I'm wondering if someone has found an easier solution? Thanks, Kevin

[John__Carter]

The Data - OLEDB utility object is a good alternative to reading large Excel files - it does not open Excel and queries the file directly. However, regardless of the method used, care should be taken with large collections as they can sap the memory of the PC, and it is sometime necessary to read data in chunks rather than in one go. I'll post an article on the Knowledgebase this week showing how it can be done.