Details for nielsjmp

nielsjmp has participated in the following threads:

Added by nielsjmp on 02 Jul 2025 at 20:26

Hi, thanks a lot for the tutorials. Im quite new in VBA but have used it to open data from a closed workbook containing a database with around 35 columns and some 15000 rows.

But I run into one weird problem that it took me some time to sort out. In my column no 13 I have some long text strings, worst case I think they can be up to 5000 characters. The recordset ("TableArr()") seems to be truncated to 255 characters. Is there a workaround on this, eventually specify the 13th column to be separately uploaded to an array with specified longer text strings?

I hope the question makes sense! Thanks again:-)

Dim Conn As ADODB.Connection

Dim PartNoRecordSet As ADODB.RecordSet

Dim DwgRecordSet As ADODB.RecordSet

Dim TableArr() As Variant

Dim RevNo As String, PartNo As String ', FirstRow() As String,

Dim PartNos() As String

Dim i As Long, j As Long, IdxDwgRev As Long, IdxPartNo As Long, NoOfRows As Long, NoOfCols As Long

ReDim PartNoDataBaseStr(1, 1)

ReDim FirstRow(1)

ReDim PartNoArr(1)

Set Conn = New ADODB.Connection