Persist Array to Table

I am receiving a multidimensional array from outside my application (via web service).  I need to persist this to a table in a database.  Is there is a simple/efficient way to process this array?  The code below is too slow Example1 as it is linear function O(m*n) see Google result:   Example2 is slightly faster (not as flexible) but it still needs to iterate the maxRow times say 5000.   I am just looking to see if there is a better way to store an array to a table.
'Example 1
    For i = 0 To maxRow
        For j= 0 To maxColumn
            'save to db
        Next j
    Next i
    'Example 2
    For i = 0 to maxRow
    next i

Open in new window

Who is Participating?
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
Not that I'm aware of ... at some point you must iterate the "rows" of your array, especially if you're not looking to simply dump into a table ... for example, if you must "massage" the data in any way (i.e. make sure a Date exists, or make sure a particular column is not null) then you don't really have a choice.

How often do you do this? I'd think you could process 5k rows pretty quickly, assuming you persist the array to disc before you work with it.
CyberUnDeadAuthor Commented:

  Thanks for the reply.   If I wanted to just simply dump to a database or file how would one accomplish that?  Again my data is an multidimensional array say MyQueryBean(rows,columns).   The class below is the structure holding the data.  The class was generated by Microsoft Office 2k3 Web Services toolkit  
Option Compare Database
Option Explicit
Public columnList As Variant
Public data As Variant

Open in new window

CyberUnDeadAuthor Commented:
I am having the Web Service provider present the data in a different format.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.