Recordset is concatenated when importing it

Hi, Im using an adodb to get data from a closed workbook, and it looked like it worked fine - until i realized it was concatenating (255 chars) the values in a column (L:L or column 12) where I have cells containing text, up to some 5000 chars, worst case maybe 10000.
The array becomes pretty big, I have around 20000 rows and 35 columns totally so reserving 10000bits for each cell might be a problem.

I have tried to import the recordset to an array as a string, but this fails, as far as I can see due to null values in the recordset. Is there a workaround where I can get the recordset ignoring the nulls (letting them be text "" or something) so I can declare the array as string instead of variant - or in another way increase the cell length. Or maybe import that column separately declaring it different? I have tried a few things but nothing has worked so far.

I have attached an example with "long text strings" in the "BOMStr" column. In the code "DataBaseDir" should be corrected to a local dir before running the code from another workbook.

In the variable TableArr you find the concatenated textstrings in TableArr(10,12), (10,13) and (10,14). The one in (10,12) should contain more than 6000chars. All 3 are truncated to 255 chars...

Please Login or Register  to view this content.

You would be better served with supplying a sample of your worksheet with no personal data. Maybe only 8-15 records and then mock up your expected solution. A day and half with no responses . I think we need to see some data.