Jaymond Flurrie
Well-known Member
- Joined
- Sep 22, 2008
- Messages
- 921
- Office Version
- 365
- Platform
- Windows
Situation shortly
1) I read from a book that "this way you can transfer a recordset to an array. I was like, "oh, ok, let's do it that way then".
2) I have 100k rows / 2400 columns of data in a text file that I need to process.
3) After I do this vArray=rs.GetRows, I begin to get errors by having empty lines in between the text file (in reality there's no empty lines, that's the error) and those lines have nothing different from the other lines in the source text file.
So my questions are as follows
1) Why to use a variant array instead of recordset, what's the big gain there?
2) What's the most likely place where the error of getting a sudden empty line to my variant array is? The transfer to the recordset or the transfer to the variant array?
1) I read from a book that "this way you can transfer a recordset to an array. I was like, "oh, ok, let's do it that way then".
2) I have 100k rows / 2400 columns of data in a text file that I need to process.
3) After I do this vArray=rs.GetRows, I begin to get errors by having empty lines in between the text file (in reality there's no empty lines, that's the error) and those lines have nothing different from the other lines in the source text file.
So my questions are as follows
1) Why to use a variant array instead of recordset, what's the big gain there?
2) What's the most likely place where the error of getting a sudden empty line to my variant array is? The transfer to the recordset or the transfer to the variant array?
