excel 2007 vba mysql to array hangs
Posted on 2010-09-09
We have the used the following routine many times in our Excel 2007 vba to get the full record set from the mysql database to an array and it has always worked in the past. Now when we try with the data base at just over 14,000 records (and about 65 columns in each record) Excel will hang on the statement myArray = rs.GetRows(). We are using uwamp as the server with mysql at version 5.1.41. Can anyone advise on why this may be occuring.
Set rs = New ADODB.Recordset
sqlstr = "SELECT * FROM members ORDER BY account_lastname ASC, account_firstname ASC"
rs.Open sqlstr, conn, adOpenDynamic, adLockOptimistic
maxarow = 0
If Not rs.EOF Then
myArray = rs.GetRows()
maxacol = UBound(myArray, 1)
maxarow = UBound(myArray, 2)