mferrisi
05-09-2007, 08:13 AM
I run a query that should create an array that is (1 T0 2000, 1 to 3). However, do to the size limits, TempM is limited to (1 to 1312, 1 To 3), and the subsequent data is not included in the array
Is there any way to increase the size of the array that I am able to create, or am I just out of luck if I want to do this in excel?
Thank you
databasename = DbConnection
querystring = "SELECT id, hist_date, total_mny FROM dbo.f_history WHERE name = 'TheName' AND type= 'accounting' ORDER BY hist_date"
TempM = sqlrequest(databasename, querystring, , 4, False)
Is there any way to increase the size of the array that I am able to create, or am I just out of luck if I want to do this in excel?
Thank you
databasename = DbConnection
querystring = "SELECT id, hist_date, total_mny FROM dbo.f_history WHERE name = 'TheName' AND type= 'accounting' ORDER BY hist_date"
TempM = sqlrequest(databasename, querystring, , 4, False)